NICEDATE ​
This version works in Student Manager
Returns formatted dates in Student Manager reports.
Reporting Area(s) ​
General
Required Parameters ​
- Date Field (i.e. cobegdate, nmaddate, rgaddate)
Optional Parameters ​
- Date Field (i.e. coenddate, nmupdate, rgupdate)
- Numeric return value:
0= spacer value if padding full date (see example #4)
3= abbreviate dates (i.e. Feb 5, Feb 5 - Mar 30)
- Numeric return value: number of desired length of string - Pads string to N characters (i.e. 20 pads return value to 20 characters)
Example(s) ​
NICEDATE(cobegdate) returns formatted course begin date (i.e. February 5, 2015)
NICEDATE(cobegdate,coenddate,3) returns formatted course begin-end dates with month(s) abbreviated (i.e. Feb 5 - Mar 30)
NICEDATE(cobegdate,coenddate,3,20) returns formatted course begin-end date with month(s) abbreviated and expression padded to 20 spaces (i.e. Feb 5 - Mar 30)
NICEDATE(cobegdate,coenddate,0,32) returns formatted course begin-end date with expression padded to 32 spaces (i.e. February 5 - March 30, 2015)
Notes ​
This function is most widely used in course reporting with the begin and end date.