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 BiasExplanation
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:
KeywordExplanationExample
(US locale)
fromStart of range (inclusive).
Optional if used in conjunction with 'to', as in the example above.
"from mar/2000" -> Mar 1st, 2000 onwards
toEnd of range (inclusive) "to mar/2000" -> Mar 31st, 2000 and before
afterStart of range (exclusive) "after mar/2000" -> Apr 1st, 2000 onwards
beforeEnd 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