Explore

Format DateTime Reference

A quick guide to help you pick the right option

Have you ever heard about the FormatDateTime() experimental formula? It allows you to format a date, time or dateTime value in various ways - but how do I know which one is which?

Well, to help me you figure that out more easily here’s a quick reference, so you know which value to pick to format your dateTime value.

The syntax is pretty simple: add the FormatDateTime() to a date value and pass two parameters: the first is the date formatting and the second is the time. There are options from 1 to 29 to date (except for 14) and from 1 to 4 to time. Set zero to omit one or the other value from the result.

Test the DateTime format

Pick an option for date and time and see the result

Select date format:

⁠

Select time format:

⁠

Result:

1/13/2026, 12:00:00 AM

⁠

Formula: Today().FormatDateTime(

[ ]

⁠

[ ]

⁠

)

⁠

Date options

Date Formatted

Formula

1/13/2026

Today().FormatDateTime(1,0)

1/13/26

Today().FormatDateTime(2,0)

1/13

Today().FormatDateTime(3,0)

January 13, 2026

Today().FormatDateTime(4,0)

Jan 13, 2026

Today().FormatDateTime(5,0)

Jan 13

Today().FormatDateTime(6,0)

13/1/2026

Today().FormatDateTime(7,0)

2026-01-13

Today().FormatDateTime(8,0)

Tue, Jan 13

Today().FormatDateTime(9,0)

Tue, Jan 13, 2026

Today().FormatDateTime(10,0)

13/01/2026

Today().FormatDateTime(11,0)

January 2026

Today().FormatDateTime(12,0)

Tuesday

Today().FormatDateTime(13,0)

Today().FormatDateTime(15,0)

January

Today().FormatDateTime(16,0)

2026

Today().FormatDateTime(17,0)

Jan 2026

Today().FormatDateTime(18,0)

13.01.2026

Today().FormatDateTime(19,0)

13.01.

Today().FormatDateTime(20,0)

13.01.26

Today().FormatDateTime(21,0)

13/01/26

Today().FormatDateTime(22,0)

13/01

Today().FormatDateTime(23,0)

Tue, 13 Jan 2026

Today().FormatDateTime(24,0)

Tue, 13 Jan

Today().FormatDateTime(25,0)

13 January 2026

Today().FormatDateTime(26,0)

13 Jan

Today().FormatDateTime(27,0)

Jan

Today().FormatDateTime(28,0)

Tue

Today().FormatDateTime(29,0)

There are no rows in this table

⁠

Time options

Time Formatted

Formula

12:00:00 AM

Today().FormatDateTime(0,1)

12:00 AM

Today().FormatDateTime(0,2)

00:00:00

Today().FormatDateTime(0,3)

00:00

Today().FormatDateTime(0,4)

There are no rows in this table

⁠

Want to print your doc?
This is not the way.

Try clicking the ··· in the right corner or using a keyboard shortcut (

CtrlP

) instead.