Relative time formats

In the Usage application, you can specify relative and absolute dates to define timeframes and intervals. There is a loose syntax for defining date and time values. (Case is not important.)

 

For

Type the following

Specific hour time

Time in 12-hour format with AM or PM; precede this time with "@".

This instant

now or n or *

Today

today

Yesterday

yesterday or now -nh (where n is number of hours behind)

Tomorrow

tomorrow or now +nh (where n is number of hours ahead)

Day

day or d

Week

week or w

Month

month or m

Year

year or y

Quarter

quarter or q

Second

second or s

Minute

minute o n

Hour

hour or h

 

For example

o        Now - specifies this instance

o        Now -10d - specifies 10 days before this time on the current day.

o        Now +3days - specifies 3 days after this time on the current day.

o        Yesterday @11:30 AM - specifies 11:30 AM on the day before the current one

o        Today @ 8:00 AM -1w - specifies 8:00 AM on the day that fell one week (7 days) before from the current day

o        Tomorrow @ 6:30 PM - specifies 6:30 PM on the day after the current one