DateFormat
Formats a date value to text based on the format provided.
See Sigma's Common Date Functions and Use Cases lab for more information about date functions, including use cases and exercises.
Usage
DateFormat(date, format)
date [required] The date or column of dates to be formatted.
format [required] The format to apply. See all supported formats here.
Examples
DateFormat(Date("2018-07-23"), "%B")
- The specified format — "%B" — ensures that this formula returns the month name of the input date (which would be "July" in this example).
DateFormat([Date], "%a %B %d %Y")
- Returns a formatted text version of each row in the [Date] column. The format applied translates to abbreviated weekday name (%a), month name (%B), day number (%d), and year (%Y).
