Skip to content
Gallery
Format DateTime Reference
Format DateTime Reference
Untitled page
More
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:
Blank
⁠
Select time format:
Blank
⁠
⁠

Result:
8/5/2024, 12:00:00 AM
⁠
⁠
Formula: Today().FormatDateTime(
[ ]
⁠
,
[ ]
⁠
)

⁠

Date options

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
Date Formatted
Formula
8/5/2024
Today().FormatDateTime(1,0)
8/5/24
Today().FormatDateTime(2,0)
8/5
Today().FormatDateTime(3,0)
August 5, 2024
Today().FormatDateTime(4,0)
Aug 5, 2024
Today().FormatDateTime(5,0)
Aug 5
Today().FormatDateTime(6,0)
5/8/2024
Today().FormatDateTime(7,0)
2024-08-05
Today().FormatDateTime(8,0)
Mon, Aug 5
Today().FormatDateTime(9,0)
Mon, Aug 5, 2024
Today().FormatDateTime(10,0)
05/08/2024
Today().FormatDateTime(11,0)
August 2024
Today().FormatDateTime(12,0)
Monday
Today().FormatDateTime(13,0)
05
Today().FormatDateTime(15,0)
August
Today().FormatDateTime(16,0)
2024
Today().FormatDateTime(17,0)
Aug 2024
Today().FormatDateTime(18,0)
05.08.2024
Today().FormatDateTime(19,0)
05.08.
Today().FormatDateTime(20,0)
05.08.24
Today().FormatDateTime(21,0)
05/08/24
Today().FormatDateTime(22,0)
05/08
Today().FormatDateTime(23,0)
Mon, 5 Aug 2024
Today().FormatDateTime(24,0)
Mon, 5 Aug
Today().FormatDateTime(25,0)
5 August 2024
Today().FormatDateTime(26,0)
5 Aug
Today().FormatDateTime(27,0)
Aug
Today().FormatDateTime(28,0)
Mon
Today().FormatDateTime(29,0)
There are no rows in this table
⁠

Time options

1
2
3
4
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.