Skip to main content
Open

Enhance CompareDate Function to Return Day Difference

Related products:Automation
  • August 7, 2026
  • 0 replies
  • 1 view

Forum|alt.badge.img+3

The CompareDate function currently returns only a binary result (0 or 1) indicating whether a given date is before, on, or after the current date, without providing the actual number of days between the two dates. This enhancement proposes updating CompareDate to return an integer value representing the day difference between the two dates, rather than a simple boolean-style indicator. Providing this level of detail would allow customers to build more precise conditional logic in automation scripts and reports that depend on the magnitude of the date difference, not just its direction.