Description
Truncates a date to the given unit. If a tz identifier is provided, uses that time zone instead of the local time zone.
Available In
- Apps
- Automations
- Analysis
Syntax
ROUNDDATETIME(date: Datetime or Date, truncation: Text, timezone?: Text)
Example
ROUNDDATETIME(@App Info.Current Date and Time, 'month', 'America/New_York') = 01/01/2019 00:00