Formats a date value into text based on the given a format.

 

Usage

DateFormat(date, format)

date [required] The date or column of dates

format [required] The format to apply. See all supported formats

 

Examples

Example #1

DateFormat(Date("2018-07-23"), "%B")

Returns July.

Example #2

DateFormat([Date], "%a %B %d %Y")

Returns a formatted text version of each row in the [Date] column.

The format applied — "%a %B %d %Y" — translates to abbreviated weekday name (%a), month name (%B), day number (%d), and year (%Y). 

Screen_Shot_2022-07-28_at_10.01.40_AM.png

See Also

Date Functions Overview