Beginning with OnePager 6.1, you can add a custom date format to your OnePager chart, if you have the need to display dates or times in a way other than the standard formats that Windows offers.
To add a custom date format, go to Home > Project View Properties > Time Axis > Calendar and click on the Custom Date Formats box.
Custom Date Format Syntax
OnePager uses an extension of the standard convention for date formats:
Days
Syntax |
Description |
Example(s) |
d |
Numeric calendar day, without leading zeros |
1 through 31 |
dd |
Numeric calendar day, with leading zeros |
01 through 31 |
a |
One-letter abbreviation for weekday name, in your local language |
S (for Sunday) through S (for Saturday) in English M (for Montag) through S (for Sonntag) in German L (for Lunes) through D (for Domingo) in Spanish |
aa |
Two-letter abbreviation for weekday name, in your local language |
Su through Sa in English Mo through So in German Lu through Do in Spanish |
aaa |
Three-letter abbreviation for weekday name, in your local language |
Sun through Sat in English Mon through Son in German Lun through Dom in Spanish |
aaaa |
Full weekday name, in your local language |
Sunday through Saturday in English Montag through Sonntag in German Lunes through Domingo in Spanish |
A |
One-letter abbreviation for weekday name, always in English |
S (for Sunday) through S (for Saturday) |
AA |
Two-letter abbreviation for weekday name, always in English |
Su through Sa |
AAA |
Three-letter abbreviation for weekday name, always in English |
Sun through Sat |
AAAA |
Full weekday name, always in English |
Sunday through Saturday |
n |
Numbered day of the week, without leading zeros |
1 through 7 |
nn |
Numbered day of the week, with leading zeros |
01 through 07 |
z |
Numbered day of the year, without leading zeros |
1 through 366 |
zz |
Numbered day of the year, with one leading zero |
01 through 366 |
zzz |
Numbered day of the year, with two leading zeros |
001 through 366 |
Note: There are several different ways to count days of the week. You can customize when your week starts Home > Project View Properties > Time Axis > Calendar. Change the First day of week dropdown to match your organization's calendar.
Weeks
Syntax |
Description |
Example(s) |
w |
Week number of the year, without leading zeros |
1 through 53 |
ww |
Week number of the year, with leading zeros |
1 through 53 |
Note: There are several different ways to count weeks of the year. You can customize how weeks are counted under Home > Project View Properties > Time Axis > Calendar. Change the First week of year dropdown to match your organization's calendar.
Months
Syntax |
Description |
Example(s) |
M |
Numeric months, without leading zeros |
1 through 12 |
MM |
Numeric months, with leading zeros |
01 through 12 |
b |
One-letter abbreviation for month name, in your local language |
J (for January) through D (for December) in English J (for Januar) through D (for Dezember) in German E (for Enero) through D (for Diciembre) in Spanish |
bb |
Two-letter abbreviation for month name, in your local language |
Ja through De in English Ja through De in German En through Di in Spanish |
bbb |
Three-letter abbreviation for month name, in your local language |
Jan through Dec in English Jan through Dez in German Ene through Dic in Spanish |
bbbb |
Full month name, in your local language |
January through December in English Januar through Dezember in German Enero through Diciembre in Spanish |
B |
One-letter abbreviation for month name, always in English |
J (for January) through D (for December) |
BB |
Two-letter abbreviation for month name, always in English |
Ja through De |
BBB |
Three-letter abbreviation for month name, always in English |
Jan through Dec |
BBBB |
Full month name, always in English |
January through December |
Quarters
Syntax |
Description |
Example(s) |
q |
Calendar quarters, without leading zeros |
1 through 4 |
Calendar quarters, with leading zeros |
01 through 04 |
Years
Syntax |
Description |
Example(s) |
y |
Two-digit year, without leading zeros |
0 through 99 |
yy |
Two-digit year, with leading zeros |
00 through 99 |
yyyy |
Four-digit year |
1999, 2018, etc. |
Note: If you wish to display a fiscal year, you can set it up Home > Project View Properties > Time Axis > Calendar. Change the First month of fiscal year dropdown to match your organization's fiscal calendar.
Hours
Syntax |
Description |
Example(s) |
h |
Hours on a 12-hour clock, without leading zeros |
1 through 12 |
hh |
Hours on a 12-hour clock, with leading zeros |
01 through 12 |
H |
Hours on a 24-hour clock, without leading zeros |
0 through 23 |
HH |
Hours on a 24-hour clock, with leading zeros |
00 through 23 |
Minutes
Syntax |
Description |
Example(s) |
m |
Minutes, without leading zeros |
0 through 59 |
mm |
Minutes, with leading zeros |
00 through 59 |
Seconds
Syntax |
Description |
Example(s) |
s |
Seconds, without leading zeros |
0 through 59 |
ss |
Seconds, with leading zeros |
00 through 59 |
Miscellaneous
Syntax |
Description |
Example(s) |
t |
One-letter AM/PM abbreviation, always in English |
A or P |
tt |
Two-letter AM/PM designation, always in English |
AM or PM |
: (Colon) |
Time separator for your local culture. In most countries, this is a colon (:), but other countries use a dot (.) |
12:00 in English 12.00 in Finnish |
:: (Double Colon) |
When the double colon is present, the English time separator (:) will be inserted, regardless of local culture. |
12:00 |
/ (Forward slash) |
Date separator for your local culture. In most countries, this is a forward slash (/), but other countries use a dot, a dash, or a space. |
02/20/2018 in English 02.20.2018 in German 02-20-2018 in French |
// (Double Forward slash) |
When the double forward slash is present, the English date separator (/) will be inserted, regardless of local culture. |
02/20/2018 |
- (Hyphen) |
Hyphen (dash) date separator |
02-20-2018 |
, (Comma) |
Comma separator |
May 1, 2020 |
S |
English ordinal indicator |
st, nd, rd, th |
"" (Double quotes) |
Custom text identifier. Any text contained within double-quotes will be displayed exactly as written. |
"Custom text" will be written as: Custom text |
'' (Single quotes) |
Custom text identifier. Any text contained within single quotes will be displayed exactly as written. |
'Custom text' will be written as: Custom text |
Example Date Formats
Here are a few examples of how to use the syntax above to create your own custom date formats. All of these use an example date of February 20, 2037 at 1:30 PM:
Syntax |
Example |
MM/dd/yyyy |
02/20/2037 |
dd-bbb-yyyy |
20-Feb-2037 |
aaaa, bbbb dS, yyyy "at" h:mm tt |
Friday, February 20th, 2037 at 1:30 PM |
"Q"q yyyy |
Q1 2037 |
"Week" w, "Day" n |
Week 8, Day 6 Note: You need to establish both your week and your day counting conventions in order for this to work correctly. Week counting is set up under Home > Project View Properties > Time Axis > Calendar. Change the First week of year dropdown to match your organization's calendar for counting weeks. To change which day is first in a given week, adjust the First day of week dropdown on the same form. |
"Fiscal" yyyy |
Fiscal 2037 Note: You need to establish your fiscal year in order for this to display correctly. Fiscal years are set up under Home > Project View Properties > Time Axis > Calendar. Change the First month of fiscal year dropdown to match your organization's fiscal calendar. |
Additional Guidance
When you add a custom date format, it will appear in all related dropdowns. For example, if you add a custom date format that uses monthly units, all other date dropdowns that measure months will give you the choice of that same custom date format, in addition to the standard Windows formats.
Last Updated: May 26, 2021