TODAY() : TODAY() : Current date

NOW() : NOW() : Current date & time

YEAR() : YEAR([Order Date]) : Extract year

MONTH() : MONTH([Order Date]) : Month number

DAY() : DAY([Order Date]) : Day of month

DATENAME() : DATENAME('weekday',[Order Date]) : Full text name

DATEPART() : DATEPART('quarter',[Order Date]) : Numeric part of date

DATEDIFF() : DATEDIFF('day',[Order Date],[Ship Date]) : Difference between dates

DATEADD() : DATEADD('year',1,[Order Date]) : Shift date by interval

DATETRUNC() : DATETRUNC('month',[Order Date]) : Truncate date to granularity

MAKEDATE() : MAKEDATE(2025,4,23) : Create date from YMD

MAKETIME() : MAKETIME(14,30,0) : Create time

DATEPARSE() : DATEPARSE('dd-MMM-yyyy','23-Apr-2025') : Parse custom string

MIN() : MIN([Order Date]) : Earliest date in partition

MAX( ) : MAX([Order Date]) : Latest date