Question

check the date is past 45 days

My scenario is to check the date past 45 days.

todate(now())-local!creat_dt return intervals(days to Seconds).

How to retrieve Days from it. Or is there an other solution to find?

You just need to compare to intervals

a!localVariables(
  local!diff: tointervalds(today()) - tointervalds(today()-40),
  tointeger(local!diff)
)

Awesome

Sign up