Skip to Main Content
Preset Feature Feedback
Status Needs review
Categories Enhancement
Created by Zachary Smith
Created on May 24, 2024

Allow the option to toggle inclusive/exclusive end dates in date filter

What is the problem or goal the end user is trying to solve or accomplish?

A date range of the previous day and current day, truncated on the day. It feels unintuitive to have to make the filter extend a day through advanced functions to include the current day.

How are they solving it currently?

Using the advanced date option to do it: DATEADD(DATETRUNC(DATETIME("NOW"), day), 1, day)

What is the recommended solution by the Customer?

Either the option to toggle inclusive or exclusive dates, or a more intuitive way to truncate for others that might not be able to figure out the advanced date option

  • Attach files