Skip to content

DATELIST ​

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

Returns listing of all meeting dates and times for a course.

Reporting Areas ​

Courses, Registrations

Required Parameters ​

  1. Course # (i.e. cocrse, rgcrse, pycrse, gccourse)

Optional Parameters ​

  1. Numeric return value: number of columns for meeting date display (i.e. 1 [default] places each session on its own line, 2 places 2 sessions on a line, etc. If you want all sessions listed on the same line use 100)
  2. Logical .t. lists only dates, .f. lists dates and times (default)
  3. Character String used to separate dates (i.e. "-", "/", " ", ","). Default is 3 spaces
  4. Column delimiter (spacing between columns if the # of columns >0) Default is CHR(9) TAB
  5. Custom return string: field(s) to return (i.e. "DTOC(crmdate)+' '+CDOW(crmdate)" returns the date and day of the week)

Examples ​

DATELIST(cocrse) returns 1-17-24 7-9pm

DATELIST(cocrse,100,.t.,",") returns 1/17/24,1/24/25

DATELIST(cocrse,1,.t.," ","","DTOC(crmdate)+' '+CDOW(crmdate)") returns 1/17/24 Friday

LOADDATE
NICEDATE