Skip to content
Gallery
Format DateTime Reference
Format DateTime Reference
Untitled page
Share
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:
8/12/2025, 12:00:00 AM
⁠
⁠
Formula: Today().FormatDateTime(
[ ]
⁠
,
[ ]
⁠
)

⁠

Date options

Date Formatted
Formula
8/12/2025
Today().FormatDateTime(1,0)
8/12/25
Today().FormatDateTime(2,0)
8/12
Today().FormatDateTime(3,0)
August 12, 2025
Today().FormatDateTime(4,0)
Aug 12, 2025
Today().FormatDateTime(5,0)
Aug 12
Today().FormatDateTime(6,0)
12/8/2025
Today().FormatDateTime(7,0)
2025-08-12
Today().FormatDateTime(8,0)
Tue, Aug 12
Today().FormatDateTime(9,0)
Tue, Aug 12, 2025
Today().FormatDateTime(10,0)
12/08/2025
Today().FormatDateTime(11,0)
August 2025
Today().FormatDateTime(12,0)
Tuesday
Today().FormatDateTime(13,0)
12
Today().FormatDateTime(15,0)
August
Today().FormatDateTime(16,0)
2025
Today().FormatDateTime(17,0)
Aug 2025
Today().FormatDateTime(18,0)
12.08.2025
Today().FormatDateTime(19,0)
12.08.
Today().FormatDateTime(20,0)
12.08.25
Today().FormatDateTime(21,0)
12/08/25
Today().FormatDateTime(22,0)
12/08
Today().FormatDateTime(23,0)
Tue, 12 Aug 2025
Today().FormatDateTime(24,0)
Tue, 12 Aug
Today().FormatDateTime(25,0)
12 August 2025
Today().FormatDateTime(26,0)
12 Aug
Today().FormatDateTime(27,0)
Aug
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 ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.