Classic VA FileMan API

Introduction to Date/Time Formats: %DT

%DT is used to validate date/time input and convert it to VA FileMan's conventional internal format: "YYYMMDD.HHMMSS", where:

• YYY is number of years since 1700 (hence always 3 digits)
  
  
• MM is month number (00-12)
  
  
• DD is day number (00-31)
  
  
• HH is hour number (00-23)
  
  
• MM is minute number (01-59)
  
  
• SS is the seconds number (01-59)

This format allows for representation of imprecise dates like JULY '78 or 1978 (which would be equivalent to 2780700 and 2780000, respectively). Dates are always returned as a canonic number (no trailing zeroes after the decimal).

Reviewed/Updated: March 8, 2007