Lookback field options
1 min
the lookback determines how far back in time an ad hoc report reaches lookback options may indicate the prior day, month or quarter a prior date or range, starts from the current date and then works back for example, the prior date is the current date minus 1 day or yesterday similarly, a previous and current month , is the current month regardless of when that falls and the month immediately before it this gives you a two month window that will always be current when the lookback states last as in last 30 days , it is indicating a time frame from the current date and going back 30 days it may also go back 60, 90, or 120 days the following is a complete list of lookback options prior day (1) one day before the current date last 7 days each of the past 7 days last 30 days last 60 days last 90 days last 120 days prior month all dates in the prior fiscal calendar month (mm/dd/yyyy) month to date current month in the current year starting with today’s date and going back to the first day of the month previous & current month from the start of the prior month to the current date prior quarter start date of last full calendar quarter to the end date of the last full calendar quarter q1 1/1 current year first quarter of the current calendar year, from 1/1 to 3/31 q2 4/1/current year second quarter of the current calendar year, from 4/1 to 6/30 q3 7/1/current year third quarter of the current calendar year, from 7/1 to 9/30 q4 10/1/last year fourth quarter of the current calendar year, from 10/1 to 12/31 quarter to date start date of current quarter to today’s date q1 start date 1/1 of the current year q2 start date 4/1 of the current year q3 start date 7/1 of the current year q4 start date 10/1 of the current year previous & current quarter start month of previous fiscal quarter to the current date year to date from january 1 of the current year to today’s date lifetime up to 400 day lookback custom date range select date range using the calendar

