Working With Dates

There are a few things to note when working with dates in Holistics.

Global Time Zone

In Holistics, All schedules (email schedules, imports, data transforms, etc...) are based on your browser's timezone.

On the other hand, Relative date/time are calculated using the Global Time Zone that is set in the Settings page. This is the organization-wide timezone.

Relative Data Syntax in Filters

Using NLP, matches operator can smartly translate the text you input to a time range. To learn more, please follow this doc.

Relative Date Syntax in Data Import

When importing data from some sources (for example, Google Analytics) you can specify the start/end date with relative date syntax:

For examples:

  • yesterday
  • today
  • 2 weeks ago
  • 1 month ago
  • 30 days ago
  • 2 weeks from now
  • last week Tuesday
  • 3rd Wednesday in November
  • last month end (the last day of the previous month)
  • last month begin (the first day of the previous month)

We also support "begin" or "end" to indicate the beginning/end of each week/month/year.

Date Format

We currently support the following date format when displaying in charts:

  • Day
  • Week
  • Month
  • Quarter
  • Year