GETCIV

Returns Civilian time using individual time fields (costhr,costmin,coendhr,coendmin).

Reporting Area(s):

Courses, Registrations

Required Parameters:

  1. Hours field (i.e. costhrs, coendhrs)
  2. Minutes field (i.e. costmin, coendmin)

Optional Parameters:

  1. Logical .t. adds a space between minutes and am/pm designation.
  2. Logical .t. shows minutes and space between am/pm designation.

Example(s):

GETCIV(costhrs,costmin) returns hour and am/pm designation e.g. 8AM.

GETCIV(costhrs,costmin) returns hour and space between am/pm designation, e.g. 8 AM

GETCIV(costhrs,costmin) returns hour and minutes with space between am/pm designation, e.g. 8:00 AM.

Notes

Time is stored in military format in the database tables.

 

Related Topics Link IconRelated Topics