ITrack/Date Fields - Revision history

Duff: Date Fields (ITrack) moved to ITrack/Date Fields

2010-10-27T19:29:54Z

Date Fields (ITrack) moved to ITrack/Date Fields

← Older revision	Revision as of 14:29, 27 October 2010
(No difference)

192.168.5.1: Added some new parsing options

2008-11-20T19:10:30Z

Added some new parsing options

← Older revision		Revision as of 14:10, 20 November 2008
Line 5:		Line 5:
	==Absolute Dates==		==Absolute Dates==
	Absolute dates are precise dates. ITrack supports two formats:		Absolute dates are precise dates. ITrack supports two formats:
	* American Format - This is the standard American 'mm/dd/yyyy' format. ITrack supports just typing in the month/day part or even just the day part. The year can be entered as a two digit or four digit number. If ~~only~~ four digits ~~are entered~~, it is treated as a year.		* American Format - This is the standard American 'mm/dd/yyyy' format. ITrack supports just typing in the month/day part or even just the day part. The year can be entered as a two digit or four digit number. If a single number is entered and it is four digits, it is treated as a year. If that number is followed by a dash and two digits then it is a year and a month. This can be useful when used with relative dates.
	* International Format - This is a format used by many nations 'dd.mm.yyyy'. Years may be two or four digits. If only four digits are entered, it is treated as a year.		International Format - This is a format used by many nations 'dd.mm.yyyy'. Years may be two or four digits. If only four digits are entered, it is treated as a year.
	* SQL Format - This is a the commonly used computer format 'yyyy-mm-dd'. ITrack supports just typing in the month-day part of even just the day part. The year can be entered as a two digit or four digit number~~. If only four digits are entered, it is treated as a year~~.		* SQL Format - This is a the commonly used computer format 'yyyy-mm-dd'. ITrack supports just typing in the month-day part of even just the day part. The year can be entered as a two digit or four digit number.

	==Relative Dates==		==Relative Dates==
Line 17:		Line 17:
	** "12/25/1985 +60d" - Sixty days after Christmas in 1985		** "12/25/1985 +60d" - Sixty days after Christmas in 1985
	** "3 -7" - Seven days before the third of this month		** "3 -7" - Seven days before the third of this month
	* "[<modifier>] <day of week>" - By day of the week. <modifier> is optional ~~and can be either a plus or minus followed by a number or~~ one of the words "this", "last", of "next" and is case insensitive. <day of week> can be "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday" or their usual shorter forms "Su(n)", "Mo(n)", "Tu(es)", "We(d)", "Th(urs)", "Fr(i)", "Sa(t)". It is case insensitive. If a plus or minus and a number is placed before the day of the week then ITrack interprets it as that man <day of week>s ago. If no number is used then ITrack assumes that the day listed is the day of the current week (even if it has passed or is yet to come). Weeks in ITrack begin on Sunday and end on Saturday. Some examples:		* "[<modifier>] <day of week>" - By day of the week. <modifier> is optional one of the words "this", "last", or "next" and is case insensitive. <day of week> can be "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday" or their usual shorter forms "Su(n)", "Mo(n)", "Tu(es)", "We(d)", "Th(urs)", "Fr(i)", "Sa(t)". It is case insensitive. If a plus or minus and a number is placed before the day of the week then ITrack interprets it as that man <day of week>s ago. If no number is used then ITrack assumes that the day listed is the day of the current week (even if it has passed or is yet to come). Weeks in ITrack begin on Sunday and end on Saturday. Some examples:
	** "Th" - The Thursday of this week.		** "Th" - The Thursday of this week.
	** "-1 Friday" - The Friday of the previous week.
	** "next sat" - The Saturday of the next week		** "next sat" - The Saturday of the next week
	** "4/1 Mon" - The Monday in the week of April first.		** "4/1 Mon" - The Monday in the week of April first.
	** "1976-06-04 Sunday" - The Sunday of the week 200 years after the the United States declared their independence.		** "1976-06-04 Sunday" - The Sunday of the week 200 years after the the United States declared their independence.
			* "[<+/->]n <day of the week>" - Days of the week can also added, subtracted or enumerated according to their order in the month. If they are being added or subtracted, use a plus or minus sign. If specifying directly, omit the sign and use the numerals 1-5 or the words "first", "second", "third", "fourth", or "fifth".
			** "-1 Friday" - The Friday of the previous week
			** "second Thursday" - The second Thursday of the month
			** "2001 3 Sun" - The third Sunday of the year 2001
			** "+5 Sa" - Five Saturdays after the one this week.
			** "01.11.08 4 Thurs" - American Thanksgiving day (the fourth Thursday of the month of November) of 2008.
	* "<special>" There are a few special strings that ITrack recognizes. While there is generally no good reason to, they can be appended to absolute dates. They are case insensitive:		* "<special>" There are a few special strings that ITrack recognizes. While there is generally no good reason to, they can be appended to absolute dates. They are case insensitive:
	** "today" - Today		** "today" - Today
	** "tomorrow" - Tomorrow		** "tomorrow" - Tomorrow
	** "yesterday" - Yesterday		** "yesterday" - Yesterday

Duff: Fixed misspelling of "international"

2008-11-20T18:26:26Z

Fixed misspelling of "international"

← Older revision		Revision as of 13:26, 20 November 2008
Line 6:		Line 6:
	Absolute dates are precise dates. ITrack supports two formats:		Absolute dates are precise dates. ITrack supports two formats:
	* American Format - This is the standard American 'mm/dd/yyyy' format. ITrack supports just typing in the month/day part or even just the day part. The year can be entered as a two digit or four digit number. If only four digits are entered, it is treated as a year.		* American Format - This is the standard American 'mm/dd/yyyy' format. ITrack supports just typing in the month/day part or even just the day part. The year can be entered as a two digit or four digit number. If only four digits are entered, it is treated as a year.
	* ~~Internatinoal~~ Format - This is a format used by many nations 'dd.mm.yyyy'. Years may be two or four digits. If only four digits are entered, it is treated as a year.		* International Format - This is a format used by many nations 'dd.mm.yyyy'. Years may be two or four digits. If only four digits are entered, it is treated as a year.
	* SQL Format - This is a the commonly used computer format 'yyyy-mm-dd'. ITrack supports just typing in the month-day part of even just the day part. The year can be entered as a two digit or four digit number. If only four digits are entered, it is treated as a year.		* SQL Format - This is a the commonly used computer format 'yyyy-mm-dd'. ITrack supports just typing in the month-day part of even just the day part. The year can be entered as a two digit or four digit number. If only four digits are entered, it is treated as a year.

192.168.5.1: Addition of information on years, the keywords "first", "second", etc... and International Date Format.

2008-11-20T17:07:57Z

Addition of information on years, the keywords "first", "second", etc... and International Date Format.

← Older revision		Revision as of 12:07, 20 November 2008
Line 5:		Line 5:
	==Absolute Dates==		==Absolute Dates==
	Absolute dates are precise dates. ITrack supports two formats:		Absolute dates are precise dates. ITrack supports two formats:
	* American Format - This is the standard American 'mm/dd/yyyy' format. ITrack supports just typing in the month/day part or even just the day part. The year can be entered as a two digit or four digit number.		* American Format - This is the standard American 'mm/dd/yyyy' format. ITrack supports just typing in the month/day part or even just the day part. The year can be entered as a two digit or four digit number. If only four digits are entered, it is treated as a year.
	* SQL Format - This is a the commonly used computer format 'yyyy-mm-dd'. ITrack supports just typing in the month-day part of even just the day part. The year can be entered as a two digit or four digit number.		* Internatinoal Format - This is a format used by many nations 'dd.mm.yyyy'. Years may be two or four digits. If only four digits are entered, it is treated as a year.
			* SQL Format - This is a the commonly used computer format 'yyyy-mm-dd'. ITrack supports just typing in the month-day part of even just the day part. The year can be entered as a two digit or four digit number. If only four digits are entered, it is treated as a year.

	==Relative Dates==		==Relative Dates==

Charwood: Date Fields moved to Date Fields (ITrack): This is an ITrack and not an ISoft thing. I'm a little isolated. Sometimes I forget that they are different things.

2008-11-19T23:21:57Z

Date Fields moved to Date Fields (ITrack): This is an ITrack and not an ISoft thing. I'm a little isolated. Sometimes I forget that they are different things.

← Older revision	Revision as of 18:21, 19 November 2008
(No difference)

Charwood: This isn't implemented too many places in the software but I used this to kind of test out how it would be and to document its eventual existence.

2008-11-19T23:21:24Z

This isn't implemented too many places in the software but I used this to kind of test out how it would be and to document its eventual existence.

New page

Most places in ITrack where dates need to be entered there exist special Date Controls. These objects have a drop down calendar and are specially designed to help people view dates visually. Some places, however, there is either little room for a large date control or for other design reasons a simple edit box is used. Even though the edit boxes aren't as visually appealing, they are still very powerful and efficient.

Date edits in ITrack can parse a large number of possible formats.

==Absolute Dates==
Absolute dates are precise dates. ITrack supports two formats:
* American Format - This is the standard American 'mm/dd/yyyy' format. ITrack supports just typing in the month/day part or even just the day part. The year can be entered as a two digit or four digit number.
* SQL Format - This is a the commonly used computer format 'yyyy-mm-dd'. ITrack supports just typing in the month-day part of even just the day part. The year can be entered as a two digit or four digit number.

==Relative Dates==
The flexibility of the date system is greatly enhanced by the allowance of relative dates. A relative date can be entered on its own (in which case it will be relative to the current date) or it can be inputted following an absolute date. Relative dates can be in many formats:
* "<+/->n <period>" - The plus or minus tells whether to add or subtrack, the number n represents an integer, and the <period> can be any of "days", "weeks", "months", or "years" or simply their first letters "d", "w", "m", and "y". The period is case insensitive and the pluralization is optional. Some examples:
** "+5 weeks" - Five weeks from now
** "-1 year" - Last year
** "+12w" - Twelve weeks from now
** "12/25/1985 +60d" - Sixty days after Christmas in 1985
** "3 -7" - Seven days before the third of this month
* "[<modifier>] <day of week>" - By day of the week. <modifier> is optional and can be either a plus or minus followed by a number or one of the words "this", "last", of "next" and is case insensitive. <day of week> can be "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday" or their usual shorter forms "Su(n)", "Mo(n)", "Tu(es)", "We(d)", "Th(urs)", "Fr(i)", "Sa(t)". It is case insensitive. If a plus or minus and a number is placed before the day of the week then ITrack interprets it as that man <day of week>s ago. If no number is used then ITrack assumes that the day listed is the day of the current week (even if it has passed or is yet to come). Weeks in ITrack begin on Sunday and end on Saturday. Some examples:
** "Th" - The Thursday of this week.
** "-1 Friday" - The Friday of the previous week.
** "next sat" - The Saturday of the next week
** "4/1 Mon" - The Monday in the week of April first.
** "1976-06-04 Sunday" - The Sunday of the week 200 years after the the United States declared their independence.
* "<special>" There are a few special strings that ITrack recognizes. While there is generally no good reason to, they can be appended to absolute dates. They are case insensitive:
** "today" - Today
** "tomorrow" - Tomorrow
** "yesterday" - Yesterday