Date-part functions - cfo.ai Docs

Date-part functions return a numeric part of a date.

year

Returns the four-digit year.

year(Date.Month)

Returns the month as a number from 1 to 12.

month(Date.Month)

Returns the day of the month from 1 to 31.

day(Date.Day)

Returns the calendar quarter from 1 to 4.

quarter(Date.Month)

Returns 1 for January through June and 2 for July through December.

half(Date.Month)

Returns the day of the week as a number.

weekday(Date.Day)
weekday(Date.Day, 2)

Without a return type, Sunday is 1 and Saturday is 7. Optional Excel-compatible return types control the starting day and numbering.

Returns the week number within the year.

weeknum(Date.Week)
weeknum(Date.Week, 21)

The optional return type follows Excel. Return type 21 uses ISO weeks.

Returns the ISO 8601 week number.

isoweeknum(Date.Week)

This is equivalent to weeknum(Date.Week, 21).