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.

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. 

 

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

 

Screen_Shot_2022-07-28_at_10.01.40_AM.png

See Also

Date Functions Overview


Was this page helpful?
Yes No