Supported formats for defining start and end time values.
To show |
Use |
For example |
Today, at the current time |
* or NOW |
* - time value is current time and day |
[n]AM this morning |
[n] or [n]AM |
2 or 2AM - time value is 2:00 AM |
[n]PM this afternoon |
[n+12] or [n]PM |
3 or 3AM - time value is 3:00 PM |
Midnight this morning |
t# |
-- |
Midnight yesterday morning |
y# |
-- |
Most recent Sunday, at 24:00 |
su# |
-- |
Most recent Monday, at 24:00 |
m# |
-- |
Most recent Tuesday, at 24:00 |
tu# |
-- |
Most recent Wednesday, at 24:00 |
w# |
-- |
Most recent Thursday, at 24:00 |
th# |
-- |
Most recent Friday, at 24:00 |
f# |
-- |
Most recent Saturday, at 24:00 |
sa# |
-- |
Any date and time |
Most standard formats |
Such as 09/15/02 |
You can create additional absolute times by concatenating an absolute time value and one or more of the supported interval time values. To concatenate the different value formats, use a +, - , or (space, which operates as "+"). For example, "su# + 8h" defines an absolute time value of the most recent Sunday, 8 hours after midnight, or Monday, 8:00 am.