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



DateFormat(date, format)

date [required] The date or column of dates

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



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). 


See Also

Date Functions Overview