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]

I am trying on change record:

try similar for value.

[miro2]

Hi @Dr Atul G- LNG 
The Planned End Date is a date-type field, so you can use it. However, in my use case, the 'Value' field is a string type, which is why I can’t use before like in your Change Request example. 

That’s why I need a condition.

[Dr Atul G- LNG]

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.

[Ankur Bawiskar]

@miro2 

share how and from where that filter is going to be applied.

Please share complete screenshots

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[miro2]

Hi @Ankur Bawiskar 

This will be used in a dashboard in Single Score visualization. The data source is my Database view combined from 3 different tables (HR Payroll, Custom, and Question Answer tables).

The 'Value' field comes from the Question Answer table (Value in my particular use case will store date in String field). Since I wasn't able to fetch the variable value directly, I had to fetch it from the Question Answer table.