Day
Returns the day of the month of a date value as a number.
See Sigma's Common Date Functions and Use Cases lab for more information about date functions, including use cases and exercises.
Usage
Day(date, [timezone])
date (required) The date from which to extract the day component.
timezone (optional) Name of IANA time zone to get the date part at (e.g., “America/Los_Angeles”). When calculating a time zone, input dates are treated as UTC.
Example
Day(Date("2007-08-14"))
- Returns 14.
Day([Date])
- Returns the day of the month of each date value in the [Date] column as a number.