NICEDATE

This version works in Student Manager. This NiceDate version works in ACEweb.

Returns formatted dates in Student Manager reports.

Reporting Area(s):

General

Required Parameters:

1. Date Field (i.e. cobegdate, nmaddate, rgaddate)

Optional Parameters:

2. Date Field (i.e. coenddate, nmupdate, rgupdate)
3. Numeric return value:
   

   0= spacer value if padding full date (see example #4)
   3= abbreviate dates (i.e. Feb 5, Feb 5 - Mar 30)

4. 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.

 

Related Topics