Reference: Tools-Dates and Times

frd

The processing of Dates and Times from data entry forms, in machine readable files, and at other times, as necessary, can be an imprecise activity. This is the result of different portions of the world using different "standards" and, indeed, individuals having specific preferences over style. Of course, RidgeStar Sites are, by their very nature, computer systems that cannot be imprecise and must have a standard and identifiable way to handle Dates and Times.

The following form permits you to enter a date and/or time value and watch how the RidgeStar routines would process it. The processing used to produce the results are documented at the bottom of this page:

Date and Time Formatting
Input
Display Date
Display Time	00:00
Display Date and Time
Internal Date
Internal Time	00:00:00
Internal Date and Time
PHP StrToTime
Day of Week	3 - Wednesday
Action	Display

The form of an input area containing a date and/or time (where mm=month, dd=day, yyyy=year, hh=hour, mm=minute, ss=second) is:

M/D/Y format: [mm[/dd[/yyyy]]] [[hh[:mm[:ss]]]]

or

Y-M-D format: [yyyy-[mm[-dd]]] [[hh[:mm[:ss]]]]

• Leading zeroes are optional in any of the elements (mm, dd, yy, hh, mm, or ss)
• the presence of a dash in the input field indicates Y-M-D format, otherwise the assumption is M/D/Y format
• If unspecified, the Month, Day, and Year will default to the current Month, Day, or Year
• if the Year is less than four digits, 2000 is added to the YY value to produce a fully formed 4 digit Year. Sites with Feature=OptionSettings operational can specify Setting=SiteOperations CenturyYear to a numeric value that is the cutoff in the current century between the prior Century and the current Century OR a relative interval value (e.g. +10 years)

Note: The logic and acceptable formats underlying the RidgeStar Time and Date parsing routines is described in the GNU Date Input Formats syntax or at the PHP site description for Relative Formats..