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) )
My scenario is to check the date from today to past 20 days how to implement this code
What do you mean with "check"? In general, you can use + and - to add or subtract days from a date.