Comparing dates in automation

Question

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 Answer

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