Comparing dates in automation

[jan_ambroz]

Hi there, 

I have automation that fetches data from Jira REST API and I would like to compare some dates from the response and one Issue date field. 

I am creating two variables:

• sprintStartDate => {{sprint.startDate.substring(0,10).toDate.jiraDate}}
• scheduledDate => {{issue.Date Scheduled}}

The output of these variables are :

2024-04-18
2024-04-17

If I use any function to compare these dates it never passes the condition. I guess I am not sending the dates correctly into compare function. 

I tried: {{scheduledDate.isAfter(sprintStartDate)}} but no output. 

How to format these dates to use them in the "Advanced compare condition"?

Thank you.

[Stefan Salzl · Accepted solution]

Hi @jan_ambroz 

as fsr as i know variables are stored as type of String. Therefore I would suggest to re-convert to date with .toDate in your comparison.

Best
Stefan