PjDateLabel enumeration (Project)
Contains constants that specify the display format for date and time labels in a timescale.
| Name | Value | Description |
|---|---|---|
| pjDay_ddd | 19 | Examples: Mon, Tue. Requires the time unit to be pjTimescaleDays. |
| pjDay_ddd_dd | 105 | Examples: Mon 30, Tue 1 |
| pjDay_ddd_m_dd | 112 | Examples: Mon S 30, Tue O 1 |
| pjDay_ddd_mm_dd | 108 | Examples: Mon 9/30, Tue 10/1 |
| pjDay_ddd_mm_dd_yy | 52 | Examples: Mon 9/30/02, Tue 10/1/02 |
| pjDay_ddd_mmm_dd | 23 | Examples: Mon Sep 30, Tue Oct 1 |
| pjDay_ddd_mmm_dd_yyy | 22 | Examples: Mon September 30 '02, Tue October 1 '02 |
| pjDay_ddd_mmmm_dd | 111 | Examples: Mon September 30, Tue October 1 |
| pjDay_dddd | 18 | Examples: Tuesday, Wednesday. |
| pjDay_ddi | 119 | Examples: Mo, Tu |
| pjDay_ddi_dd | 106 | Examples: Mo 30, Tu 1 |
| pjDay_ddi_m_dd | 113 | Examples: Mo S 30, Tu O 1 |
| pjDay_ddi_mm_dd | 109 | Examples: Mo 9/30, Tu 10/1 |
| pjDay_di | 20 | Examples: M, T |
| pjDay_di_dd | 107 | Examples: M 30, T 1 |
| pjDay_di_m_dd | 114 | Examples: M S 30, T O 1 |
| pjDay_di_mm_dd | 110 | Examples: M 9/30, T 10/1 |
| pjDay_didd | 121 | Examples: M30, T1 |
| pjDay_m_dd | 115 | Examples: S 30, O 1 |
| pjDay_mm_dd | 27 | Examples: 9/30, 10/1 |
| pjDay_mm_dd_yy | 26 | Examples: 9/30/02, 10/1/02 |
| pjDay_mmm_dd | 25 | Examples: Sep 30, Oct 1 |
| pjDay_mmm_dd_yyy | 24 | Examples: Sep 30 '02, Oct 10 '02 |
| pjDayFromEnd_Day_dd | 41 | Examples: Day 2, Day 1, Day -1, Day -2 from the project end. |
| pjDayFromEnd_dd | 54 | Examples: 2, 1, -1, -2 |
| pjDayFromEnd_Ddd | 53 | Examples: D2, D1, D-1, D-2 |
| pjDayFromStart_Day_dd | 40 | Examples: Day -2, Day -1, Day 1, Day 2 from the project start. |
| pjDayFromStart_dd | 56 | Examples: -2, -1, 1, 2 |
| pjDayFromStart_Ddd | 55 | Examples: D-2, D-1, D1, D2 |
| pjDayOfMonth_dd | 21 | Examples: 30, 1 |
| pjDayOfYear_dd | 118 | Examples: 77, 78 |
| pjDayOfYear_dd_yyy | 116 | Examples: 77 '10, 78 '10 |
| pjDayOfYear_dd_yyyy | 117 | Examples: 77 2010, 78 2010 |
| pjHalfYear_h | 128 | Examples: 1, 2. Requires the time unit to be pjTimescaleHalfYears. |
| pjHalfYear_Hh | 127 | Examples: H1, H2 |
| pjHalfYear_Hh_yyy | 126 | Examples: H1 '10, H2 '10 |
| pjHalfYear_hhh_Half | 123 | Examples: 1st Half, 2nd Half |
| pjHalfYear_hHyy | 129 | Examples: 1H10, 2H10 |
| pjHalfYear_Hlf_h | 125 | Examples: Half 1, Half 2 |
| pjHalfYear_Hlf_h_yyyy | 124 | Examples: Half 1, 2010; Half 2, 2010 |
| pjHalfYearFromEnd_h | 135 | Examples: 2, 1, -1, -2. Half years from the project end date. |
| pjHalfYearFromEnd_Half_h | 133 | Examples: Half 2, Half 1, Half -1, Half -2 |
| pjHalfYearFromEnd_Hh | 134 | Examples: H2, H1, H-1, H-2 |
| pjHalfYearFromStart_h | 132 | Examples: -2, -1, 1, 2. Half years from the project start date. |
| pjHalfYearFromStart_Half_h | 130 | Examples: Half -2, Half -1, Half 1, Half 2 |
| pjHalfYearFromStart_Hh | 131 | Examples: H-2, H-1, H1, H2 |
| pjHour_ddd_mmm_dd_hhAM | 28 | Examples: Wed Mar 18, 8 AM; Wed Mar 18, 9 AM. Requires the time unit to be pjTimescaleHours. |
| pjHour_hh | 32 | Examples: 8, 9, 10, 11 |
| pjHour_hh_mmAM | 30 | Examples: 8:00 AM, 9:00 AM |
| pjHour_hhAM | 31 | Examples: 8AM, 9AM |
| pjHour_mm_dd_hhAM | 120 | Examples: 3/18 8 AM, 3/18 9 AM |
| pjHour_mmm_dd_hhAM | 29 | Examples: Mar 18, 8 AM; Mar 18, 9 AM |
| pjHourFromEnd_hh | 77 | Examples: 3, 2, 1, -1, -2 hours from the project end. |
| pjHourFromEnd_Hhh | 76 | Examples: H3, H2, H1, H-1, H-2 |
| pjHourFromEnd_Hour_hh | 39 | Examples: Hour 3, Hour 2, Hour 1, Hour -1, Hour -2 |
| pjHourFromStart_hh | 79 | Examples: -2, -1, 1, 2, 3 hours from the project start. |
| pjHourFromStart_Hhh | 78 | Examples: H-2, H-1, H1, H2, H3 |
| pjHourFromStart_Hour_hh | 38 | Examples: Hour -2, Hour -1, Hour 1, Hour 2, Hour 3 |
| pjMinute_hh_mmAM | 33 | Examples: 8:00 AM, 8:01 AM, 8:02 AM. Requires the time unit to be pjTimescaleMinutes. |
| pjMinute_mm | 34 | Examples: 0, 1, 2, ..., 59 minutes |
| pjMinuteFromEnd_Minute_mm | 37 | Examples: Minute 181, Minute 180, ..., Minute 1, Minute -1 from the project end. |
| pjMinuteFromEnd_mm | 81 | Examples: 181, 180, ..., 1, -1 |
| pjMinuteFromEnd_Mmm | 80 | Examples: M181, M180, ..., M1, M-1 |
| pjMinuteFromStart_Minute_mm | 36 | Examples: Minute -2, Minute -1, Minute 1, ... Minute 180 from the project start. |
| pjMinuteFromStart_mm | 83 | Examples: -2, -1, 1, ..., 180 |
| pjMinuteFromStart_Mmm | 82 | Examples: M-2, M-1, M1, ..., M180 |
| pjMonth_m | 11 | Examples: M, A, M, J, J. Requires the time unit to be pjTimescaleMonths. |
| pjMonth_mm | 57 | Examples: 11, 12, 1, 2 |
| pjMonth_mm_yy | 86 | Examples: 3/10, 4/10, 5/10 |
| pjMonth_mm_yyy | 85 | Examples: 3 '10, 4 '10, 5 '10 |
| pjMonth_mmm | 10 | Examples: Mar, Apr, May |
| pjMonth_mmm_yyy | 8 | Examples: Mar '10, Apr '10, May '10 |
| pjMonth_mmmm | 9 | Examples: March, April, May |
| pjMonth_mmmm_yyyy | 7 | Examples: March 2010, April 2010, May 2010 |
| pjMonthFromEnd_mm | 59 | Examples: 2, 1, -1, -2 months from the project end. |
| pjMonthFromEnd_Mmm | 58 | Examples: M2, M1, M-1, M-2 |
| pjMonthFromEnd_Month_mm | 45 | Examples: Month 2, Month 1, Month -1, Month -2 |
| pjMonthFromStart_mm | 61 | Examples: -2, -2, 1, 2 months from the project start. |
| pjMonthFromStart_Mmm | 60 | Examples: M-2, M-1, M1, M2 |
| pjMonthFromStart_Month_mm | 44 | Examples: Month -2, Month -1, Month 1, Month 2 |
| pjQuarter_q | 62 | Examples: 3, 4, 1. Requires the time unit to be pjTimescaleQuarters. |
| pjQuarter_Qq | 6 | Examples: Q3, Q4, Q1 |
| pjQuarter_Qq_yyy | 4 | Examples: Q3 '10, Q4 '10, Q1 '11 |
| pjQuarter_qqq_Quarter | 2 | Examples: 3rd Quarter, 4th Quarter, 1st Quarter |
| pjQuarter_qQyy | 51 | Examples: 3Q10, 4Q10, 1Q11 |
| pjQuarter_Qtr_q | 5 | Examples: Qtr 3, Qtr 4, Qtr1 |
| pjQuarter_Qtr_q_yyyy | 3 | Examples: Qtr3, 2010; Qtr4, 2010; Qtr1, 2011 |
| pjQuarterFromEnd_q | 64 | Examples: 5, 4, 3, 2, 1, -1 quarters from the project end. |
| pjQuarterFromEnd_Qq | 63 | Examples: Q5, Q4, Q3, Q2, Q1, Q-1 |
| pjQuarterFromEnd_Quarter_q | 47 | Examples: Quarter 5, Quarter 4, Quarter 3, Quarter 2, Quarter 1, Quarter -1 |
| pjQuarterFromStart_q | 66 | Examples: -5, -4, -3, -2, -1, 1 quarters from the project start. |
| pjQuarterFromStart_Qq | 65 | Examples: Q-5, Q-4, Q-3, Q-2, Q-1, Q1 |
| pjQuarterFromStart_Quarter_q | 46 | Examples: Quarter -5, Quarter -4, Quarter -3, Quarter -2, Quarter -1, Quarter 1 |
| pjThirdsOfMonths_dd | 136 | Examples: 1, 11, 21, 1. Requires the time unit to be pjTimescaleThirdsOfMonths. |
| pjThirdsOfMonths_ddd | 137 | Examples: B, M, E, B |
| pjThirdsOfMonths_dddd | 138 | Examples: Beginning, Middle, End, Beginning |
| pjThirdsOfMonths_mm_dd | 139 | Examples: 3/1, 3/11, 3/21, 4/1 |
| pjThirdsOfMonths_mm_dd_yy | 145 | Examples: 3/1/10, 3/11/10, 3/21/10, 4/1/10 |
| pjThirdsOfMonths_mm_ddd | 140 | Examples: 3/B, 3/M, 3/E, 4/B |
| pjThirdsOfMonths_mm_ddd_yy | 146 | Examples: 3/B/10, 3/M/10, 3/E/10, 4/B/10 |
| pjThirdsOfMonths_mmm_dd | 142 | Examples: Mar 1, Mar 11, Mar 21, Apr 1 |
| pjThirdsOfMonths_mmm_dd_yy | 147 | Examples: Mar 1, '10; Mar 11, '10; Mar 21, '10; Apr 1, 10 |
| pjThirdsOfMonths_mmm_ddd | 143 | Examples: Mar B, Mar M, Mar E, Apr B |
| pjThirdsOfMonths_mmm_ddd_yy | 148 | Examples: Mar B, '10; Mar M, '10; Mar E, '10; Apr B '10 |
| pjThirdsOfMonths_mmmm_dd | 144 | Examples: March 1, March 11, March 21, April 1 |
| pjThirdsOfMonths_mmmm_dd_yyyy | 149 | Examples: March 1, 2010; March 11, 2010; March 21, 2010; April 1, 2010 |
| pjThirdsOfMonths_mmmm_dddd | 141 | Examples: March Beginning, March Middle, March End, April Beginning |
| pjThirdsOfMonths_mmmm_dddd_yyyy | 150 | Examples: March Beginning, 2010; March Middle, 2010; March End, 2010; April Beginning, 2010 |
| pjWeek_ddd_dd | 88 | Examples: Sun 21, Sun 28, Sun 4. Requires the time unit to be pjTimescaleWeeks. |
| pjWeek_ddd_m_dd | 97 | Examples: Sun M 21, Sun M 28, Sun A 4 |
| pjWeek_ddd_mm_dd | 90 | Examples: Sun 3/21, Sun 3/28, Sun 4/4 |
| pjWeek_ddd_mm_dd_yy | 100 | Examples: Sun 3/21/10, Sun 3/28/10, Sun 4/4/10 |
| pjWeek_ddd_mmm_dd | 93 | Examples: Sun Mar 21, Sun Mar 28, Sun Apr 4 |
| pjWeek_ddd_mmm_dd_yyy | 101 | Examples: Sun Mar 21, '10; Sun Mar 28, '10; Sun Apr 4, '10 |
| pjWeek_ddd_mmmm_dd | 96 | Examples: Sun Mar 21, Sun March 28, Sun Apr 4 |
| pjWeek_ddd_mmmm_dd_yyy | 102 | Examples: Sun Mar 21, '10; Sun March 28, '10; Sun Apr 4, '10 |
| pjWeek_ddd_ww | 103 | Examples: Sun 12, Sun 13, Sun 14 |
| pjWeek_ddi_m_dd | 98 | Examples: Sun M 21, Sun M 28, Sun A 4 |
| pjWeek_ddi_mm_dd | 91 | Examples: Su 3/21. Su 3/28, Su 4/4 |
| pjWeek_ddi_mmm_dd | 94 | Examples: Su Mar 21, Su Mar 28, Su Apr 4 |
| pjWeek_di_m_dd | 99 | Examples: S M 21, S M 28, S A 4 |
| pjWeek_di_mm_dd | 92 | Examples: S 3/21, S 3/28, S 4/4 |
| pjWeek_di_mmm_dd | 95 | Examples: S Mar 21, S Mar 28, S Apr 4 |
| pjWeek_m_dd | 89 | Examples: M21, M28, A 4 |
| pjWeek_mm_dd | 17 | Examples: 3/21, 3/28, 4/4 |
| pjWeek_mm_dd_yy | 16 | Examples: 3/21/10. 3/28/10, 4/4/10 |
| pjWeek_mmm_dd | 15 | Examples: Mar 21, Mar 28, Apr 4 |
| pjWeek_mmm_dd_yyy | 13 | Examples: Mar 21, '10; Mar 28, '10; Apr 4, '10 |
| pjWeek_mmmm_dd | 14 | Examples: March 21, March 28, April 4 |
| pjWeek_mmmm_dd_yyyy | 12 | Examples: March 21, 2010; March 28, 2010; April 4, 2010 |
| pjWeekDayOfMonth_dd | 87 | Examples: 21, 28, 4 |
| pjWeekFromEnd_Week_ww | 43 | Examples: Week 2, Week 1, Week -1 from the project end. |
| pjWeekFromEnd_ww | 68 | Examples: 2, 1, -1 |
| pjWeekFromEnd_Www | 67 | Examples: W2, W1, W-1 |
| pjWeekFromStart_Week_ww | 42 | Examples: Week -1, Week 1, Week 2 from the project start. |
| pjWeekFromStart_ww | 70 | Examples: -1, 1, 2 |
| pjWeekFromStart_Www | 69 | Examples: W-1, W1, W2 |
| pjWeekNumber_dd_ww | 104 | Examples: 1 12, 1 13, 1 14 (day 1 of week 12, day 1 of week 13, and so forth) |
| pjWeekNumber_ww | 50 | Examples: 12, 13, 14 |
| pjYear_yy | 75 | Examples: 10, 11, 12. Requires the time unit to be pjTimescaleYears. |
| pjYear_yyy | 1 | Examples: '10, '11, '12 |
| pjYear_yyyy | 0 | Examples: 2010, 2011, 2012 |
| pjYearFromEnd_Year_yy | 49 | Examples: Year 2, Year 1, Year -1 from the project end. |
| pjYearFromEnd_yy | 72 | Examples: 2, 1, -1 |
| pjYearFromEnd_Yyy | 71 | Examples: Y2, Y1, Y-1 |
| pjYearFromStart_Year_yy | 48 | Examples: Year -1, Year 1, Year 2 from the project start. |
| pjYearFromStart_yy | 74 | Examples: -1, 1, 2 |
| pjYearFromStart_Yyy | 73 | Examples: Y-1, Y1, Y2 |
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.