MEETDATES

Returns the month and dates of a course.

Reporting Area(s)

Courses, Registrations

Required Parameters

1. Course # (i.e. cocrse, rgcrse, pycrse)
2. Numeric Return Value:

1= MM/DD/YYYY with each date on same line separated by commas

2= MM/DD/YYYY with each date on a separate line

3= MM/DD with each date on same line separated by commas

4= MM/DD with each date on a separate line

5= Mon DD with each date on same line separated by commas

6= Mon DD with each date on separate line

7= Month DD with each date on same line separated by commas

8 = Month DD with each date on separate line

Optional Parameters

3. Condition to return dates based on CRSEROOM table (i.e. "crmdate <> ctod(01/15/2015)")

Example(s)

MEETDATES(cocrse,1) returns 11/01/2015, 11/02/2015, 11/03/2015

MEETDATES(cocrse,4) returns 11/01

MEETDATES(cocrse,5) returns Nov 1, Nov 2, Nov 3

MEETDATES(cocrse,7) returns November 1, November 2, November 3

Related Functions

ADDCRDAT
DATELIST
HOLIDAY
NICEDATE
SHOHDATE