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

 

Screen_Shot_2022-07-28_at_10.01.40_AM.png

See Also

Date Functions Overview


Was this page helpful?
Yes No