System Date Explanations
PREVIOUS
Previous Day – 12am previous day to 12:00am current day.
Previous Week – Monday of the previous week (12:00am) to Sunday of the previous week (11:59:59:59 pm).
Previous Bi-Week – Monday two weeks prior to current week's Monday (12:00 am) to Saturday prior to current week's Saturday (11:59:59:59 pm).
Previous Month – 12:00am on the first day of the previous month to 11:59:59:59pm on the last day of the previous month.
Previous Quarter – 1st day of the month of the quarter previous to current day's quarter at 12:00am through the last day of quarter previous to the current day's quarter at 11:59:59:59 pm. (Quarters: Q1 = Jan – Mar Q 2 = Apr – June Q3 = July –Sept Q4 = Oct - Dec)
Previous Month YTD – January 1 at 12:00am of this year through the last day of the prior month at 11:59:59:59 pm. (I ran a report in April 2013, and the report dates were 01/01/2013 – 3/31/2013).
Previous Month Previous YTD – January 1 at 12am of the previous year through the last day of the prior month (and the previous year) at11:59:59:59 pm. (I ran a report in April 2013, and the report dates were 01/01/2012 – 3/31/2012).
Previous Month Year – First day of this month, but in the previous year, through the end of previous month in this year. (Example: I ran the report April 23, 2013. The report dates were April 1, 2012 – March 31, 2013).
Previous Year – January 1 through December 31 of the previous year.
NEXT
Next Day – 12am next day to 12:00am following day.
Next Week – Monday of the next week (12:00am) to Sunday of the next week (11:59:59:59 pm).
Next Bi-Week – Monday after current week's Monday (12:00 am) to Sunday two weeks after current week's Sunday (11:59:59:59 pm).
Next Month – 12:00am on the first day of the next month to 11:59:59:59pm on the last day of the next month.
Next Quarter – 1st day of the month of the quarter after current day's quarter at 12:00am through the last day of the quarter after the current day's quarter at 11:59:59:59 pm.
Next Month YTD – Beginning day at 12:00am of the year containing the next month through the last day of next month at 11:59:59 pm.
Next Month Previous YTD – End date is the last day of the next month within the year prior to that month's year. Begin date id the first day of the year that contains the end date.
Next Month Year – End date is the last day of the current month. Begin date is the first day of the current month in the prior year.
Next Year – Start of next year through end of next year.
Current
Current Day – 12am today to 11:59:59 pm today.
Current Week – 12am Monday of the current week to 11:59:59:59 pm Sunday of the current week.
Current Bi-Week – Sunday one week prior to current week's Sunday (12:00 am) to Saturday after current week's Saturday (11:59:59:59 pm).
Current Month – 12:00am on the first day of the current month to 11:59:59:59pm on the last day of the current month.
Current Quarter – 1st day of the month of the current day's quarter at 12:00am through the last day of the current day's quarter at 11:59:59:59 pm.
Current Month YTD – 12am January 1st of this year through the last day of the current month at 11:59:59:59 pm.
Current Month Previous YTD – 12am on the first day of this month for the previous year through the last day of this month for the previous year. (Example: I ran a report on 4/23/13 and the dates were Jan 1, 2012 to April 30, 2012.
Current Month Year – 12am on the first day of next month, for the previous year through the last day of this month of this year. (Example: I ran a report on 4/23/13 and the dates were May 1, 2012 to April 30, 2013).
Current Year – 12am January 1st of this year through December 31st at 11:59:59 pm of this year.