Enhanced Handling of Date and Time Values

We’ve updated the behavior of the DATE() function to make it consistent and predictable across all use cases — it will now always return a date-only value without a time. To complement this change, we’re introducing a new function: DATETIME(), which returns a precise date-time value and gives users full control over date/time-based calculations.
‍

Key Highlights‍

• DATE() now always returns a date-only value with the time stripped, regardless of context.
• New DATETIME() function introduced for working with exact date-time values.
• Improved consistency in formulas like DATEDIFF() and NOW() across different timezones.
• Backend calculations use the workspace timezone, while display uses the user’s timezone.
• Full support for parsing date and time strings in various formats.
‍

How it Works

• Consistent DATE() behavior: Strips time information from any input.
• New DATETIME() function: Returns a full date-time value.
• Timezones handled predictably: Input is evaluated in workspace timezone, display is in user’s timezone.
‍

These updates ensure that formulas using dates and times are now consistent, accurate, and easier to reason about—especially across different timezones. Whether you're building deadline reminders, aging reports, or time-sensitive automations, you now have the precision you need.