FunctionsDate & Time

to_yyyymm

Converts a date/time value to an integer key in YYYYMM form. This is useful for building sortable time keys without string formatting.

to_yyyymm(…) → Int64

Kind · scalar

Converts a date/time value to an integer key in YYYYMM form. This is useful for building sortable time keys without string formatting.

Part of the Date & Time family.

to_year_week

Returns a combined year-week identifier for the input date/time (for example YYYYWW). Use this for grouping by ISO weeks in reporting.

to_yyyymmd_dhhmmss

Converts a date/time value to a sortable date-time key in the legacy YYYYMMD_DHHMMSS family. In V1 this variant returns the same numeric layout as to_yyyymmddhhmmss.