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.


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.



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



See Also

Date Functions Overview

Was this page helpful?
Yes No