CERTDATE ​
Returns date in formal date format (i.e., 10th day of January, 2013)
Reporting Area(s) ​
Courses, Registrations
Required Parameters ​
None
Optional Parameters ​
- Date Field (i.e. cobegdate, coenddate, rgaddate)
--OR-- Character String in Date Format (i.e. "01/01/2013").
- Numeric Return Value:
0-returns date in formal format (i.e. 10th day of January, 2013)
1-returns date in the following format: 10 January, 2013
- Character Return Value: "F" returns date in French (i.e. 10 Janvier, 2013). IMPORTANT: can only be used when parameter 2 is set to 1.
Example(s) ​
CERTDATE(cobegdate) returns course begin date in formal format (i.e. 10th day of January, 2013)
CERTDATE("01/10/2007") returns" 10th day of January, 2013"
CERTDATE() returns system date (i.e. if computer date is Jan 10, 2013, returns 10th day of January, 2013)
CERTDATE(cobegdate,1) returns date as 10 January, 2013
CERTDATE(cobegdate,1,"F") returns date in French, i.e. 10 Janvier, 2013
Notes ​
If no parameter is passed, the system (current) date is returned.