How to conver a txt string with Lot Datecode into a Jira Calendar date

[Marco Ugolotti]

Hello Everyone,

I am trying to create an automation to covert a formatting text field (previously automated and extracted from a serial number) into a calendar date:

This is the source text format "YYYY - WKYY"  - this field is called {{issue.customerfield_10375}}

where YYYY is the year, and YY is the week number. WK is just static and = week.

I would like to create an automation that can transform the field above to a JIRA format date MM/DD/YY.

Can someone help?

Thanks so much

[Karan Sachdev]

Hey @Marco Ugolotti

Welcome to Atlassian Community!

Here's a KB article with a rule along the similar lines: Automation rule to fetch the date from a string and store it into a date field.

However, in your case, the date isn't directly present in the string field, so it will require more steps. You can extract the week number from your string into a different field or variable, multiply it by 7, then change it into month and date based on the number of days elapsed.

However, you may need more specific detail in your string, as it doesn't cover which day of the YYth week it is. so multiplying it by 7 will always give you the first day of the week.

I hope this should give you a start for your requirement.

Thanks!