Several special date and date/time transforms are available.
The following transforms convert a date or date/time where the date is specified as the number of days since the base date
specified in the
Base Date for Days Count value on the Date Constants pane:
- Days
- DaysHHMM
- DaysHHMMSS
- DaysHHMMSShh
The following transforms return the first day of the month for a given year and month:
- YYYYMM01
- YYMM01
- MMYY01
- MMYYYY01
The following transforms return the last day of the month for a given year and month:
- YYMM31
- YYYYMM31
- MMYY31
- MMYYYY31
The following transforms return the first day of the year for a given year:
The following transforms return the last day of the year for a given year: