HRSTODATE ​
Returns the number of hours the course has been held to date.
Reporting Area(s) ​
Attendance Tracking, Courses
Required Parameters ​
- Course #(i.e. cocrse,rgcrse,atcrse)
Optional Parameters ​
- Date to use when calculating hours held. Default is current date.
- If entering a specific date, you must use the CTOD() function.
- If using parameters 3 or 4, you must enter a date using the CTOD() function, or use the DATE() function to use the current date.
- Logical .t. returns percentage of hours held.
- Logical .t. returns percentage of hours remaining. Note: if using this option, parameter 3 must also be set to .t.
- Start Date. If entered, hours will be counted from this date until date entered in parameter 2. Default is course begin date. If entering a specific date, you must use the CTOD() function.
Example(s) ​
HRSTODATE(cocrse) returns hours held from course begin date to today's date.
HRSTODATE(cocrse,ctod([12/31/2015])) returns hours held from course begin date to 12/31/2015.
HRSTODATE(cocrse,date(),.t.) returns percentage of hours held from course begin date to today's date.
HRSTODATE(cocrse,date(),.t.,.t.) returns percentage of hours remaining from course begin date to today's date.
HRSTODATE(cocrse,date(),.t.,.t.,ctod([10/29/2015])) returns percentage of hours remaining from 10/29/2015 to today's date.