sales@onepager.com +1.303.779.0344

Adding a Custom Date Format

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

qq

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

dddd, 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.