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?
Discussion posts and replies are publicly visible
You just need to compare to intervals
a!localVariables( local!diff: tointervalds(today()) - tointervalds(today()-40), tointeger(local!diff) )
Awesome