Date Name functions

    The date name 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

DATENAME(yy, Fld)

Quarter

DATENAME(qq, Fld)

Month

DATENAME(mm, Fld)

Day of Year

DATENAME(dy, Fld)

Day

DATENAME(dd, Fld)

Week

DATENAME(ww, Fld)

Weekday

DATENAME(dw, Fld)

Hour

DATENAME(hh, Fld)

Minute

DATENAME(mi, Fld)

Second

DATENAME(ss, Fld)

Millisecond

DATENAME(ms, Fld)