TimescaleEdit Method
Formats timescales for the Gantt Chart, Resource Graph, Task Usage, and Resource Usage views.
Syntax
expression**.TimescaleEdit(MajorUnits, MinorUnits, MajorLabel, MinorLabel, MajorAlign, MinorAlign, MajorCount, MinorCount, MajorTicks, MinorTicks, Enlarge, Separator, MajorUseFY, MinorUseFY, TopUnits, TopLabel, TopAlign, TopCount, TopTicks, TopUseFY, HideMajorTier, HideMinorTier, HideTopTier)**
*expression * Optional. An expression that returns an Application object.
MajorUnits Optional Long. The major units for the timescale. Can be one of the following PjTimescaleUnit constants: pjTimescaleYears, pjTimescaleHalfYears, pjTimescaleQuarters, pjTimescaleMonths, pjTimscaleThirdsOfMonths, pjTimescaleWeeks, pjTimescaleDays, pjTimescaleHours, or pjTimescaleMinutes.
MinorUnits Optional Long. The minor units for the timescale. Can be one of the PjTimescaleUnit constants.
MajorLabel Optional Long. The major label for the timescale. Can be one of the following PjDateLabel constants:
pjTimescaleYears
| Constant | Example of date format |
|---|---|
| pjYear_yyyy | 2002, 2003 |
| pjYear_yyy | '02, '03 |
| pjYear_yy | 02, 03 |
| pjYearFromEnd_yy | 3, 2, 1 (year from the finish date of the project) |
| pjYearFromEnd_Yyy | Y3, Y2, Y1 (year from the finish date of the project) |
| pjYearFromEnd_Year_yy | Year 2, Year 1 (year from the finish date of the project) |
| pjYearFromStart_yy | 1, 2, 3 (year from the start date of the project) |
| pjYearFromStart_Yyy | Y1, Y2, Y3 (year from the start date of the project) |
| pjYearFromStart_Year_yy | Year 1, Year 2 (year from the start date of the project) |
pjTimescaleHalfYears
| Constant | Example of date format |
|---|---|
| pjHalfYear_h | 1, 2 |
| pjHalfYear_Hh | H1, H2 |
| pjHalfYear_Hh_yyy | H1 '02, H2 '02 |
| pjHalfYear_hhh_Half | 1st Half, 2nd Half |
| pjHalfYear_hHyy | 1H02, 2H02 |
| pjHalfYear_Hlf_h | Half 1, Half 2 |
| pjHalfYear_Hlf_h_yyyy | Half 1, 2002; Half 2, 2002 |
| pjHalfYearFromEnd_h | 2, 1 (half year from the finish date of the project) |
| pjHalfYearFromEnd_Half_h | Half 2, Half 1 (half year from the finish date of the project) |
| pjHalfYearFromEnd_Hh | H2, H1 (half year from the finish date of the project) |
| pjHalfYearFromStart_h | 1, 2 (half year from the start date of the project) |
| pjHalfYearFromStart_Half_h | Half 1, Half2 (half year from the start date of the project) |
| pjHalfYearFromStart_Hh | H1, H2 (half year from the start date of the project) |
pjTimescaleQuarters
| Constant | Example of date format |
|---|---|
| pjQuarter_q | 1, 2 |
| pjQuarter_qQyy | 1Q02, 2Q02 |
| pjQuarter_qqq_Quarter | 1st Quarter, 2nd Quarter |
| pjQuarter_Qq | Q1, Q2 |
| pjQuarter_Qq_yyy | Q1 '02, Q2 '02 |
| pjQuarter_Qtr_q | Qtr 1, Qtr 2 |
| pjQuarter_Qtr_q_yyyy | Qtr 1, 2002; Qtr 2, 2002 |
| pjQuarterFromEnd_q | 3, 2, 1 (quarter from the finish date of the project) |
| pjQuarterFromEnd_Qq | Q3, Q2, Q1 (quarter from the finish date of the project) |
| pjQuarterFromEnd_Quarter_q | Quarter 2, Quarter 1 (quarter from the finish date of the project) |
| pjQuarterFromStart_q | 1, 2, 3 (quarter from the start date of the project) |
| pjQuarterFromStart_Qq | Q1, Q2, Q3 (quarter from the start date of the project) |
| pjQuarterFromStart_Quarter_q | Quarter 1, Quarter 2 (quarter from the start date of the project) |
pjTimescaleMonths
| Constant | Example of date format |
|---|---|
| pjMonth_mm | 9, 10 |
| pjMonth_mm_yy | 9/02, 10/02 |
| pjMonth_mm_yyy | 9 '02, 10 '02 |
| pjMonth_m | S, O |
| pjMonth_mmm | Sep, Oct |
| pjMonth_mmm_yyy | Sep '02, Oct '02 |
| pjMonth_mmmm | September, October |
| pjMonth_mmmm_yyyy | September 2002, October 2002 |
| pjMonthFromEnd_mm | 5, 4 (months from the finish date of project) |
| pjMonthFromEnd_Mmm | M5, M4 (months from the finish date of project) |
| pjMonthFromEnd_Month_mm | Month5, Month4 (months from the finish date of project) |
| pjMonthFromStart_mm | 1, 2 (months from the start date of project) |
| pjMonthFromStart_Mmm | M1, M2 (months from the start date of project) |
| pjMonthFromStart_Month_mm | Month1, Month2 (months from the start date of project) |
pjTimescaleThirdsOfMonths
Constant |
Example of date format |
|---|---|
| pjThirdsOfMonths_dd | 1, 11, 21 |
| pjThirdsOfMonths_ddd | B, M, E |
| pjThirdsOfMonths_dddd | Beginning, Middle, End |
| pjThirdsOfMonths_mm_dd | 9/1, 9/11, 9/21 |
| pjThirdsOfMonths_mm_dd_yy | 9/1/02, 9/11/02, 9/21/02 |
| pjThirdsOfMonths_mm_ddd_yy | 9/B/02, 9/M/02, 9/E/02 |
| pjThirdsOfMonths_mm_ddd | 9/B, 9/M, 9/E |
| pjThirdsOfMonths_mmm_dd | Sep 1, Sep 11, Sep 21 |
| pjThirdsOfMonths_mmm_dd_yy | Sep 1, '02; Sep 11, '02; Sep 21 '02 |
| pjThirdsOfMonths_mmm_ddd | Sep B, Sep M, Sep E |
| pjThirdsOfMonths_mmm_ddd_yy | Sep B, '02; Sep M, '02; Sep E, '02 |
| pjThirdsOfMonths_mmmm_dd | September 1, September 11, September 21 |
| pjThirdsOfMonths_mmmm_dd_yyyy | September 1, 2002; September 11, 2002; September 21, 2002 |
| pjThirdsOfMonths_mmmm_dddd_yyyy | September Beginning 2002, September Middle 2002, September End 2002 |
| pjThirdsOfMonths_mmmm_dddd | September Beginning, September Middle, September End |
pjTimescaleWeeks
| Constant | Example of date format |
|---|---|
| pjWeek_mm_dd | 9/30, 10/1 |
| pjWeek_mm_dd_yy | 9/30/02, 10/1/02 |
| pjWeek_m_dd | S 30, O 1 |
| pjWeek_mmm_dd | Sep 30, Oct 1 |
| pjWeek_mmm_dd_yyy | Sep 30, '02; Oct 1 '02 |
| pjWeek_mmmm_dd | September 30, October 1 |
| pjWeek_mmmm_dd_yyyy | September 30, 2002; October 1, 2002 |
| pjWeek_di_mm_dd | M 9/30, T 10/1 |
| pjWeek_di_m_dd | M S 30, T O 1 |
| pjWeek_di_mmm_dd | M Sep 30, T Oct 1 |
| pjWeek_ddi_mm_dd | Th 1/31, Th 2/7 |
| pjWeek_ddi_m_dd | Mo 9/30, Tu 10/1 |
| pjWeek_ddi_mmm_dd | Mo Sep 30, Tu Oct 1 |
| pjWeek_ddd_mm_dd | Mon 9/30, Tue 10/1 |
| pjWeek_ddd_mm_dd_yy | Mon 9/30/02, Tue 10/1/02 |
| pjWeek_ddd_dd | Mon 30, Tue 1 |
| pjWeek_ddd_ww | Sun 40, Sun 40 (first day of week, number of week in year) |
| pjWeek_ddd_m_dd | Mon S 30, Tue O 1 |
| pjWeek_ddd_mmm_dd | Mon Sep 30, Tue Oct 1 |
| pjWeek_ddd_mmm_dd_yyy | Mon Sep 30, '02; Tue Oct 1, '02 |
| pjWeek_ddd_mmmm_dd | Mon September 30, Tue October 1 |
| pjWeek_ddd_mmmm_dd_yyy | Mon September 30, '02; Tue October 1, '02 |
| pjWeekDayOfMonth_dd | 30, 1 (number of day in month) |
| pjWeekFromEnd_Week_ww | Week 4, Week 3 (weeks from the end date of the project) |
| pjWeekFromEnd_ww | 4, 3 (weeks from the end date of the project) |
| pjWeekFromEnd_Www | W4, W3 (weeks from the end date of the project) |
| pjWeekFromStart_Week_ww | Week 1, Week 2 (weeks from the start date of the project) |
| pjWeekFromStart_ww | 1, 2 (weeks from the start date of the project) |
| pjWeekFromStart_Www | W1, W2 (weeks from the start date of the project) |
| pjWeekNumber_dd_ww | 3 41, 4 41 (number of day in week and number of week in year) |
| pjWeekNumber_ww | 41, 41 (number of week in year) |
pjTimescaleDays
| Constant | Example of date format |
|---|---|
| pjDay_mm_dd | 9/30, 10/1 |
| pjDay_mm_dd_yy | 9/30/02, 10/1/02 |
| pjDay_m_dd | S 30, O 1 |
| pjDay_mmm_dd | Sep 30, Oct 1 |
| pjDay_mmm_dd_yyy | Sep 30, '02; Oct 1, '02 |
| pjDay_di | M, T |
| pjDay_di_mm_dd | M 9/30, T 10/1 |
| pjDay_di_dd | M 30, T 1 |
| pjDay_di_m_dd | M S 30, T O 1 |
| pjDay_didd | M30, T1 |
| pjDay_ddi | Mo, Tu |
| pjDay_ddi_mm_dd | Mo 9/30, Tu 10/1 |
| pjDay_ddi_dd | Mo 30, Tu 1 |
| pjDay_ddi_m_dd | Mo S 30, Tu O 1 |
| pjDay_ddd | Mon, Tue |
| pjDay_ddd_mm_dd | Mon 9/30, Tue 10/1 |
| pjDay_ddd_mm_dd_yy | Mon 9/30/02, Tue 10/1/02 |
| pjDay_ddd_dd | Mon 30, Tue 1 |
| pjDay_ddd_m_dd | Mon S 30, Tue O 1 |
| pjDay_ddd_mmm_dd | Mon Sep 30, Tue Oct 1 |
| pjDay_ddd_mmm_dd_yyy | Mon Sep 30, '02; Tue Oct 1, '02 |
| pjDay_ddd_mmmm_dd | Mon September 30, Tue October 1 |
| pjDay_dddd | Monday, Tuesday |
| pjDayFromEnd_dd | 4, 3 (the day from the finish date of the project) |
| pjDayFromEnd_Ddd | D4, D3 (the day from the finish date of the project) |
| pjDayFromEnd_Day_dd | Day 4, Day 3 (the day from the finish date of the project) |
| pjDayFromStart_dd | 1, 2 (the day from the start date of the project) |
| pjDayFromStart_Ddd | D1, D2 (the day from the start date of the project) |
| pjDayFromStart_Day_dd | Day 1, Day 2 (the day from the start date of the project) |
| pjDayOfMonth_dd | 30, 1 (the day of the month) |
| pjDayOfYear_dd | 273, 274 (the day of the year) |
| pjDayOfYear_dd_yyyy | 273 2002, 274 2002 (the day of the year followed by the year) |
| pjDayOfYear_dd_yyy | 273 '02, 274 '02 (the day of the year followed by the year) |
pjTimescaleHours
Constant |
Example of date and time format |
|---|---|
| pjHour_mm_dd_hhAM | 9/30 11 AM, 10/1 12 PM |
| pjHour_hh | 11, 12 |
| pjHour_hh_mmAM | 11:00 AM, 12:00 PM |
| pjHour_hhAM | 11 AM, 12 PM |
| pjHour_mmm_dd_hhAM | Sep 30, 11 AM; Oct 1, 12 PM |
| pjHour_ddd_mmm_dd_hhAM | Mon Sep 30, 11 AM; Mon Oct 1, 12 PM |
| pjHourFromEnd_hh | 3, 2, 1 (hour from the finish date of the project) |
| pjHourFromEnd_Hhh | H3, H2, H1 (hour from the finish date of the project) |
| pjHourFromEnd_Hour_hh | Hour 2, Hour 1 (hour from the finish date of the project) |
| pjHourFromStart_hh | 1, 2, 3 (hour from the start date of the project) |
| pjHourFromStart_Hhh | H1, H2, H3 (hour from the start date of the project) |
| pjHourFromStart_Hour_hh | Hour 1, Hour 2 (hour from the start date of the project) |
pjTimescaleMinutes
| Constant | Example of time format |
|---|---|
| pjMinute_hh_mmAM | 11:45 AM, 11:46 AM |
| pjMinute_mm | 45, 46 |
| pjMinuteFromEnd_mm | 3, 2, 1 (minute from the finish date of the project) |
| pjMinuteFromEnd_Mmm | M3, M2, M1 (minute from the finish date of the project) |
| pjMinuteFromEnd_Minute_mm | Minute 2, Minute 1 (minute from the finish date of the project) |
| pjMinuteFromStart_mm | 1, 2, 3 (minute from the start date of the project) |
| pjMinuteFromStart_Mmm | M1, M2, M3 (minute from the start date of the project) |
| pjMinuteFromStart_Minute_mm | Minute 1, Minute 2 (minute from the start date of the project) |
MinorLabel Optional Long. The minor label for the timescale. Can be one of the PjDateLabel constants. The MinorLabel argument is influenced by the value of MinorUnits in the same manner as MajorLabel is influenced by MajorUnits.
MajorAlign Optional Long. The alignment of major units on the timescale. Can be one of the following PjAlignment constants: pjLeft, pjCenter, or pjRight.
MinorAlign Optional Long. The alignment of minor units on the timescale. Can be one of the PjAlignment constants.
MajorCount Optional Integer. The number of major timescale units to appear together.
MinorCount Optional Integer. The number of minor timescale units to appear together.
MajorTicks Optional Boolean. True if Project displays ticks between the major timescale units.
MinorTicks Optional Boolean. True if Project displays ticks between the minor timescale units.
Enlarge Optional Integer. A number from 25 to 1000 that specifies the scaling factor for the timescale.
Separator Optional Boolean. True if Project draws a line between the major and minor timescales.
MajorUseFY Optional Boolean. True if the timescale label specified with MajorLabel is based on a fiscal year. False if the timescale label is based on a calendar year. The default value is True.
MinorUseFY Optional Boolean. True if the timescale label specified with MinorLabel is based on a fiscal year. False if the timescale label is based on a calendar year. The default value is True.
TopUnits Optional Long. The units for the top timescale. Can be one of the PjTimescaleUnit constants.
TopLabel Optional Long. The label for the top timescale. Can be one of the PjDateLabel constants.
TopAlign Optional Long. The alignment of top units on the timescale. Can be one of the following PjAlignment constants.
TopCount Optional Integer. The number of top timescale units to appear together.
TopTicks Optional Boolean. True if Project displays ticks between the top timescale units.
TopUseFY Optional Boolean. True if the top timescale label specified with TopLabel is based on a fiscal year. False if the top timescale label is based on a calendar year. The default value is True.
HideMajorTier Optional Boolean. True if Project hides the top (major) timescale row from the view. The default value is False.
HideMinorTier Optional Boolean. True if Project hides the middle (minor) timescale row from the view. The default value is False.
HideTopTier Optional Boolean. True if Project hides the top timescale row from the view. The default value is False.
Remarks
The TimescaleEdit method is only available when the active view is the Gantt Chart, Resource Graph, Resource Usage, or Task Usage view.
Using the TimescaleEdit method without specifying any arguments displays the Timescale dialog box with the Timescale tab selected.
Applies to | Application Object
See Also | Timescale Method | TimeScaleData Method | TimescaleNonWorking Method