Date Part functions

    The date part functions are listed next (we only specify the MS-SQL Server version of the interpretation of the functions):

Option name in the popup list

Inserted string (where Fld is the selected field)

Year

DATEPART(yy, Fld)

Quarter

DATEPART(qq, Fld)

Month

DATEPART(mm, Fld)

Day of Year

DATEPART(dy, Fld)

Day

DATEPART(dd, Fld)

Week

DATEPART(ww, Fld)

Weekday

DATEPART(dw, Fld)

Hour

DATEPART(hh, Fld)

Minute

DATEPART(mi, Fld)

Second

DATEPART(ss, Fld)

Millisecond

DATEPART(ms, Fld)