Zoomdata Version

Preset Time Ranges

The following table describes all of the preset time ranges available in Zoomdata.

Preset type Start date End date
Current Hour Beginning of the current hour Current time
Current Minute Beginning of the current minute Current time
Current Month First day of the current month (for example, 08/01/2018 12:00:00 AM) Last day of the current month (for example, 08/31/2018 11:59:59 PM)
Current Month-to-Date First day of the current month (for example, 08/01/2018 12:00:00 AM) Current date and time
Current Quarter First day of the current quarter (for example, 07/01/2018 12:00:00 AM) Last day of the current quarter (for example, 09/30/2018 11:59:59 PM)
Current Quarter-to-Date First day of the current quarter (for example, 07/01/2018 12:00:00 AM) Current date and time
Current Week Sunday of the week with current day (for example, Sunday, 08/16/2018 12:00:00 AM) Saturday of the week with current day (for example, 08/22/2018 11:59:59 PM)
Current Week-to-Date Sunday of the week with current day (for example, Sunday, 08/16/2018 12:00:00 AM) Current date and time
Current Year First day of the current year (for example, 01/01/2018 12:00:00 AM) Last day of the current year (for example, 12/31/2018 11:59:59 PM)
Current Year-to-Date First day of the current year (for example, 01/01/2018 12:00:00 AM) Current date and time
Max Available Range Minimum time value in the data set known to Zoomdata Maximum time value in the data set known to Zoomdata
Previous Hour Beginning of the previous hour (for example, Aug 20 2018 12:00:00 PM) End of the previous hour (for example, Aug 20 2018 12:59:59 PM)
Previous Minute Beginning of the previous minute End of the previous minute
Previous Month First day of the previous month (for example, 07/01/2018 12:00:00 AM) Last day of the previous month (for example, 07/31/2018 11:59:59 PM)
Previous Month-to-Date First day of the previous month (for example, 07/01/2018 12:00:00 AM) Same date and time last month (for example, 07/20/2018 1:00:00 PM) or the last day of previous month (if, for example, today is 07/31/2018 1:00:00 PM, the end date will be 06/30/2018 11:59:59 PM
Previous Quarter First day of the previous quarter (for example, 04/01/2018 12:00:00 AM) Last day of the previous quarter (for example, 06/30/2018 11:59:59 PM)
Previous Quarter-to-Date First day of the previous quarter (for example, 04/01/2018 12:00:00 AM) Same date and time last quarter (for example, 07/20/2018 1:00:00 PM) or the last day of corresponding month last quarter (if, for example, today is 07/20/2018 1:00:00 PM, the end date will be 06/30/2018 11:59:59 PM)
Previous Week Sunday of the previous week (for example, 08/09/2018 12:00:00 AM) Saturday of the previous week (for example, 08/15/2018 11:59:59 PM)
Previous Week-to-Date Sunday of the previous week (for example, 08/09/2018 12:00:00 AM) 7 days before current day (for example, 08/132018 1:00:00 PM)
Previous Year First day of the previous year (for example, 01/01/2018 12:00:00 AM) Last day of the previous year (for example, 12/31/2018 11:59:59 PM)
Previous Year-to-Date First day of the previous year (for example, 01/01/2018 12:00:00 AM) Same date and time last year (for example, 08/20/2018 1:00 PM)
Rolling 7 days 7 days before the current date and time Current date and time
Rolling 24 hours 24 hours before the current date and time Current date and time
Rolling 30 days 30 days before the current date and time Current date and time
Rolling 90 days 90 days before the current date and time Current date and time
Rolling 365 days 365 days before the current date and time Current date and time
Rolling Hour 60 minutes before the current date and time Current date and time
Rolling Minute One minute before the current date and time Current date and time
Today Start of the current day (for example, 08/20/2018 12:00:00 AM) Current date and time
Yesterday Beginning of the previous day (for example, 08/19/2018 12:00:00 AM) End of the previous day (08/19/2018 11:59:59 PM)

Was this topic helpful?