Compare between two date custom fields condition and if true/false thn edit action feild

Kiran Kumar_ga3yum

Please help

Compare between two date custom fields condition and if true/false thn edit action field.

 

If duedate is greater than enddate

then edit action field should be true

 

If duedate is lesser than enddate

then edit action field should be false

 

If duedate is equal to enddate

then edit action field should be true

Bill Sheboy

Hi @Kiran Kumar 

For a question like this please post an image of the complete rule and the audit log details showing the rule execution.  Those will provide context for the community to offer suggestions.

 

Until we see those...

You are trying to compare data value using a text formatted version of the dates.

When doing that, particularly to test for less than / greater than relationships, always order the date components so they align with the testing.  To do this, I recommend using the jiraDate format or "yyyy-MM-dd".

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Date-format---

Otherwise they will not "sort" in the order you expect.

 

Kind regards,
Bill