NICETIME

Translates military time into civilian time format.

Reporting Area(s):

Courses, Registrations

Required Parameters:

  1. Time field (i.e. cocrsetm)

Optional Parameters:

  1. Logical .t. use Time from Costhr,costmin,coendhr,coendmin numeric fields. Setting to .t. will not show minutes (i.e. 7AM-9AM) unless you also set parameter #4 to .t.
  2. Numeric return value: number of desired length of string - Pads string to N characters (i.e. 20 pads return value to 20 characters)
  3. Logical .t. always shows the minutes designation.

Example(s):

NICETIME(cocrsetm) returns course meeting time in civilian time format (e.g. 7:00 am to 9:00 am)

NICETIME(cocrsetm,.f.,25) returns course meeting time in civilian time padded to 25 spaces (e.g. 7:00 am to 9:00 am)

NICETIME(cocrsetm,.t.,,.t.) returns course meeting time with minutes (e.g. 7:00 am to 9:00 am)

Notes

Time is stored in military format in the database tables.

 

Related Topics Link IconRelated Topics