General date format | Meaning | Examples |
now | The date and time of right now | now |
today | The date of today, time defaults to midnight at the beginning of today. | tod
today 10:55
|
tomorrow | The date of tomorrow | tom 9:20 |
forever | The largest possible time value, effectively the end of time | forever
forev
|
n minutes | The number of minutes in the future. |
1mi
3 minutes 5mins |
n minutes ago | The number of minutes in the past. | 2m ag
3 minutes ago 66mins ago |
n hours | The number of hours in the future. | 1h
3hours 5h |
n hours ago | The number of hours in the past. | 2hag
3 hours ago 6h ago |
n days | The number of days in the future. “1 day” is the same as “tomorrow” | 1d
3day 5d 12:00 |
n days ago | The number of days in the past. “1 day ago” is yesterday | 2dag
3 day ago 6d ago |
n weeks | The number of weeks in the future. If today is Wednesday, then “2 weeks” would be wednesday 2 weeks from today. “1 week” is the same as “7 days” | 2 w
3 weeks 15:00
|
n weeks ago | The number of weeks in the past. “1 week ago” is the same as “7 days ago” | 3wag
6week ago 3w ag 21:30 |
n months | This day of the month a number of months in the future. | 2m
3month
|
n months ago | This day of the month a number of months in the past. | 1mag
4 mon ago
|
n years | Todays date a number of years in the future. “1 year” is the same as “12 months” | 1y
2 year
|
n years ago | Todays date a number of years in the past. “1 year ago” is the same as “12 months ago” | 2yag
3 y ago
|
dd/mm/yyyy | (Only if your administrator has chosen your local date
format as “dd/mm/yyyy”)
The exact date given.
|
12/5/99 13:00
1/1/00
5/9/2001
08:00 30/12/1999 |
mm/dd/yyyy | (Only if your administrator has chosen your local date
format as “mm/dd/yyyy”)
The exact date given.
|
5/12/99 13:00
1/1/00
9/5/2001
08:00 12/30/1999 |
yyyymmdd | The exact date given. | 20000101 12:00
20011225
|