Date format smart value.

[PhilSpo]

Hello,

Using Automation for Jira I am simply adding some comments to the ticket using SmartValues.

The field in question is 'Target start' (custom field from advanced roadmaps)

The field itself displays on the issues as:

 

However when I put it into the automation: 

'This work has been scheduled to commence on {{Target start}}'

It comes out as:

Any idea how i can change the format into DD-MM-YYYY ?

Many Thanks

Phil

[Nic Brough -Adaptavist- · Accepted solution]

It is wrong, but it is possible to do it accidentally.

The usual culprit is an import.  If your import data for an issue contains a created date, that can be any value - the importers are not there to judge your data, they'll simply import it.  That means you can future-date the issue creation and then have history entries that pre-date the apparent creation.

The other methods would be database hacking, scripts doing the wrong things, or bugs (although I don't know of any date bugs in JIRA or the bigger add-ons that might do this)

So, there is something wrong in your database, but generally, it won't actually cause you any problems, other than some graphs and reports looking a little bit odd (or possibly crashing if the add-on can't handle it)y

I'd fix it by running a one-off script to find and update the dates, although you'd need a way to identify them and a rule for what dates to put into "created"