All Opmantek applications that handle time-series data use a common mechanism for parsing start and end times, which supports a large number of different formats listed below.
Default Format
The default format is the specific "DD-MON-YYYY HH:MM:SS", which you will have seen already in the Quick Search field.
Absolute Date Formats
- Dow, dd Mon yy
- Dow, dd Mon yyyy
- Dow, dd Mon
- dd Mon yy
- dd Mon yyyy
- Month day{st,nd,rd,th}, year
- Month day{st,nd,rd,th}
- Mon dd yyyy
- yyyy/mm/dd
- yyyy-mm-dd
- yyyy/mm
- mm/dd/yy
- mm/dd/yyyy
- mm/yy
Relative Date Formats
- count "days"
- count "weeks"
- count "months"
- count "years"
- Dow "after next"
- Dow "before last"
- "next" Dow
- "tomorrow"
- "today"
- "yesterday"
- "last" dow
- "last week"
- "now"
- "now" "+" count units
- "now" "-" count units
- "+" count units
- "-" count units
- count units "ago"
Absolute Time Formats
- hh:mm:ss[.ddd]
- hh:mm
- hh:mm[AP]M
- hh[AP]M
- hhmmss[[AP]M]
- "noon"
- "midnight"
Relative Time Formats
- count "minutes" (count can be franctional "1.5" or "1 1/2")
- count "seconds"
- count "hours"
- "+" count units
- "-" count units
- count units "ago"