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.
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.
- Returns 14.
- Returns the day of the month of each date value in the [Date] column as a number.