You should use the shorthand method to enter dates (if you prefer the long display for dates, change the format – see Formatting a date).
These are all OK to enter:
3-6-64
12/2/1995
01.01.95
September 12, 1995
But these will be treated as text only:
3rd June 1964
September 12th, 1995
If you don’t use the shorthand method, Ability could treat your entry as text and you won’t be able to change the format or perform date arithmetic.
You can enter the year as two or four digits. Two digit years below 30 will default to the 21st century (see Year 2000). For example:
Enter |
Date stored as |
1/1/20 |
1/1/2020 |
1/1/29 |
1/1/2029 |
1/1/30 |
1/1/1930 |
For a description of how Ability deals with dates and time, see Date and time functions.