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.
date [required] The date or column of dates to be formatted.
format [required] The format to apply.
Note: Our custom date formatting uses built-in warehouse functionality, and warehouses vary in what specific date formats they support. Our list of common date formats originates from the d3-time-format module and should be considered as a rough guide only.
- 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).