Condition for 60 day date validation

[miro2]

Hi,

I have to create a condition to meet the below requirement:
Date of today is greater than Date of field 'Sent for Approval' + 60 days. The Date of field 'Sent for Approval' is a variable and I was able to add its value in the Dashboard using database view. I want to check which condition will be better: 

javascript:gs.daysAgoStart(60)

or '60@days@ago'?

The value field is the date of the field 'Sent for Approval'

or

[Dr Atul G- LNG · Accepted solution]

Hi @miro2 

That’s a challenge. You need to store this in a proper date format first; then you can compare it. Otherwise, there’s no easy or direct way to do it. A date can be compared to another date, but a date versus a string cannot.

[Dr Atul G- LNG]

so you want 

Today date is greater then appvla +60 days?

Liek

30th Jan > approval date 15th Oct+60 days

[miro2]

Hi @Dr Atul G- LNG  
yes, like in your example: Today > Value field 'Sent for Approval'( e.g. any date in Oct) + 60 days

[Dr Atul G- LNG]

So in this, are you storing the approval date plus 60 days in another field? then it is easy to get it.

[miro2]

@Dr Atul G- LNG 
No, I'm storing the approval date only in 'Value', and in the condition I need to use 60 days to meet the requirements.