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

Offset Values