Date and Date/Time mismatch

Marc Thomson_3mmgmn

I have an automation that is populating an issue's Due Date from another Date/Time custom field using this:

{{field."Change Date/Time".jiraDate}}

I have automation working when the Date/Time field has a time before 5:59 PM. When the time is set to 6:00 PM, the field populated using jiraDate moves to the next day.

This seems to be obvious that it's tied to a UTC conversion issue. Question is, how do I get the date field correct from the Date/Time field so they match?

Bill Sheboy

Hi @Marc Thomson 

Have you tried using the convertToTimeZone() function as part of your comparison condition?  That will ensure your math is based on the time zone you want to use.

Kind regards,
Bill