Due Date Automation Fills in Incorrect Date

[Michael Manes]

Hello,

I am trying to create an automation that extracts a date out of the description field and updates the Due Date on the issue. I thought I had it working, but I have tested different dates, and it puts it 10 days out instead of the date in the description. The flow validates but updates the field with incorrect info. Here are my variable and work items. 
I had the Date in the issue as 04/30/2025 but it autofilled the Due Date as 04/26/205.

[Michael Manes · Accepted solution]

I was searching and saw that the outside form doesn't format that date like mm/dd/yyyy they can enter it in free. So, we get m/dd/yy or m/dd/yyyy etc. I need to make the outside forms date format to be mm/dd/yyyy.
This actually works great for pulling the date out of a description field. :)  I just tested it with mm/dd/yyyy and it fills in the correct date every time.

[Trudy Claspill]

Hello @Michael Manes 

As a debugging technique add Log actions to your rule to print into the rule log fe

• the Description field content
• the smart value you are using to set the variable 
• the smart value you are using to set the due date field

Then run the rule again and share rule log file content with us.