Decision table - Date comparison

[KameshAnandan]

Hi,

In the decision table , I am trying to compare the date passed with the current date(now) and find the date difference and check it against a number.

The condition that I want to check is , if the given input date is before 120 days:

date(input.lastUpdatedDate) - date("now")  >= 120

As per the documentation, the existing date expression gives us unix timestamp in seconds, I want to get difference in days.

Input data :
{
"input" : {
"lastUpdatedDate": "2022-01-01"
}
}

Please suggest.

[KameshAnandan]

Got the below expression that works for me :

(date('now') - date(input.lastUpdatedDate)) / 86400 >= 120