Date Range Input
Note: Tedhi supports all locales, however this usage page assumes the use of the US locale. Notes on the differences in some other locales are included.Basic Format - "mar/1987 to 2012"
Specify ranges using as much detail as you wish and let Tedhi fill in the blanks. Ranges are inclusive by default, so the above range is from Mar 1st, 1987 to Dec 31st, 2012.
Supports numeric and alphabet months. Supports 2-digit and 4-digit years.
Locale support:
Year, month and day are ordered according to the locale.
Shorthand - "mar/2015"
Ranges can be written in their short form when they apply to a discrete unit:
Example (US locale) | Explanation |
---|---|
2/mar/2015 | Mar 2nd, 2015 only |
mar/2015 | Mar 1st to 31st, 2015 |
2015 | Jan 1st to Dec 31st, 2015 |
Omitting One Year - "mar to apr/1995"
The year specified on one part of the range implies the year for the other part:
Examples (US locale) | Explanation |
---|---|
mar to apr/1995 mar/1995 to apr |
Mar 1st to Apr 30th, 1995 |
apr to mar/1995 apr/1994 to mar |
Apr 1st, 1994 to Mar 31st, 1995 |
Omitting All Years - "mar to apr"
The year can be omitted entirely, in which case it is filled in based on the current date.
The exact year filled in depends on the configured Year Bias, the default is NEAREST:
Year Bias | Explanation |
---|---|
NEAREST | Year defaulted such that the parsed range most closely overlaps the current date |
CURRENT | Year defaulted to the year of the current date. Note: errors on invalid ranges such as "apr to jan" (treated as, eg, apr/2000 to jan/2000) |
PAST/FUTURE | At least one of the dates in the range are on the current date or in the past/future |
STRICTLY PAST/FUTURE | Both of the dates in the range are on the current date or in the past/future |
Numeric Months and 2-digit Years - "10/5/12 to 10/7/12"
Months may be specified using numbers or names, and years may be 2-digit or 4-digit. Numeric months and 2-digit years may be used in partial dates, provided the dates can be parsed unambiguously:
Example (US locale) | Explanation |
---|---|
10/2013 | Oct 1st to 31st, 2013 |
10/13/05 | Oct 13th, 2005 |
10/13 | can't be parsed unambiguously |
Rapid Data Entry - "10052012 to 100712"
Dates may be specified using the 8-digit or 6-digit rapid entry notations. Year, month, day must all be included and ordered according to the locale.
Examples:
Example (US locale) | Explanation |
---|---|
10052013 | Oct 5th, 2013 |
100513 | Oct 5th, 2013 |
Advanced Formats - "after 20/5/2012"
Use any of the following keywords followed by a date and separated by spaces or commas:
Keyword | Explanation | Example (US locale) |
---|---|---|
from | Start of range (inclusive). Optional if used in conjunction with 'to', as in the example above. |
"from mar/2000" -> Mar 1st, 2000 onwards |
to | End of range (inclusive) | "to mar/2000" -> Mar 31st, 2000 and before |
after | Start of range (exclusive) | "after mar/2000" -> Apr 1st, 2000 onwards |
before | End of range (exclusive) | "before mar/2000" -> Feb 29th, 2000 and before |
Keywords can be combined using spaces and/or commas:
Example (US locale) | Explanation |
---|---|
from mar to apr/1995 | Mar 1st to Apr 30th, 1995 |
after mar/1990, before mar/1995 | Apr 1st, 1990 to Feb 28th, 1995 |
from sep before nov/2010 | Sep 1st to Oct 31st, 2010 |