Automation for sprintstart date and start date doesn't give the right date

[Max]

I have an automation (see below) that sets the Start date to the Sprint.startDate whenever I change the value of a sprint. The automation works. But it changes to a day before. It does the same for the Sprint End and Due date. 

For example: My sprint starts the 2nd of October, I add the sprint, the Start date becomes the 1st of October. I've seen that this probably comes due to the fact that my timezone is different to the Jira time zone. But I just want it to set the value the same. How can I do that? 

I've tried removing the .jqlDate, but then I get an error due to date formatting. Before that I used jiraDate, but that first introduced the date. 

[Christos Markoulatos]

Hey @Max 

I have a suspicion that this is a time zone mismatch. Jira stores dates in UTC, and jqDate may not apply time zone correction for your local time zone.

Try using jiraDate instead of jqDate:

{{issue.Sprint.startDate.jiraDate}}

{{issue.Sprint.endDate.jiraDate}}

Hope tis helps and let me know if it worked!

[Max]

Hi! I just tested it and it doesn't seem to work. I still get the date of the day before.