Automation compare Variable to date

Question

I am trying to get an automation to work.

I have set a variable and used Reg ex to get the data from the description.

What I want to do is an Advanced Compare condition to say if by variable is after today.

I can not get it to work. Im guessing that my date formats are not correct but don't know where to look.

Can anyone help

Yatish Madhav · Answer

Thanks @Peter Weir - this has help me. I have upvoted as answer. Thank you

bmccoy · Answer

Hi Peter,

Glad to hear you got it working.  I think if you want to do a greater than comparison, you will need to use the date functions for the comparison and check for true/false values

The advanced condition will look a bit like

{{issue.description.match("date created: ?(.*)").toDate.isAfter(now)}}

equals

true

Cheers,
Brydie

Peter Weir_5iumv7 · Answer

So I have got it working so just in case anyone has a similar requirement

In the Description of the ticket I had

date created: 2021-01-17

In Automation I create a variable called createddate as follows

{{issue.description.match("date created: ?(.*)").toDate.jiraDate}}

I also created a variable called datetoday

I can then do and Advance compare condition that says

{{createddate}} equals {{date today}}

Granted in the request was to do greater but I realised that in my use case I actually needed equal. I have not tested but I assume I could change it to be greater than and it should work.

Thanks for the help however.