DATETH

Returns formal format of day with "th", "nd", or "rd".

Reporting Area(s):

Courses, Registrations

Required Parameters:

  1. Date field (cobegdate, DATE(), coenddate)

Optional Parameters:

None

Example(s):

DATETH(cobegdate) returns formal format of course begin date (i.e. 17th)

DATETH(DATE()) returns formal format of current date (i.e. 2nd)

Notes:

Use on certificate reports where formal day is required.

 

Related Topics Link IconRelated Topics