Relative Time Entries

When entering the Start and End times for Excel Add-in queries and exports, you can already enter them as exact literal dates and times such as 1/28/14 09:00:00 in the query windows like Query Calculated Data, or you can use a cell reference to an exact time, or use an Excel function such as =Now() or =Today(). Apart from the mentioned ways, you can use relative time entries using a base value and an offset value as described in the following tables.

For example, you can use Yesterday+8H for 8am yesterday or Now-15m for 15 minutes before the current time. The typical use of a relative time entry, is to type the time values using a base and an offset into the start and end time of the Query window or the Export window, instead of having to put =Now() or =Today() in a cell and making a cell reference to that, or use the base Monday to produce weekly reports.

Base Values

Base ValueDescription
NowThe current date and time.
TodayThe current date at midnight.
YesterdayThe previous day at midnight.
SundayToday or the most recent Sunday at midnight.
MondayToday or the most recent Monday at midnight.
TuesdayToday or the most recent Tuesday at midnight.
WednesdayToday or the most recent Wednesday at midnight.
ThursdayToday or the most recent Thursday at midnight.
FridayToday or the most recent Friday at midnight.
SaturdayToday or the most recent Saturday at midnight.

Offset Values

Offset ValueDescription
d

One 24 hour day

h

One hour

m

One minute

s

One second