Confiforms Date Issues

[rachel sebben]

Using a Confiform to create a Jira Issue and trying to set Date.  I define a date field and use "DATE" with a format of dd/mm/yyyy. When moving date to the DueDate I use Jira.Date:

"duedate": "[entry.EPCOREDueDt.jiraDate]",

First problem is the date selection field is acting strangely.  The calendar pick form returns a bizzarre month.  If I select Feb 29. 2024, it will return 29/51/2024.  If I manually enter the date as 29/02/2024, it will set the due date in the Jira ticket to 29 Jan 2024.  

I have tried using different formats such as dd/mmm/yyyy, mmddyyyy etc. 

Not sure what is going on. 

[Alex Medved _ConfiForms_ · Accepted solution]

Hi @rachel sebben and welcome to this community

mm defines minutes, not months - see https://docs.oracle.com/javase/8/docs/api/java/text/SimpleDateFormat.html

So, it's should be something like

dd/MM/yyyy

Alex

[rachel sebben]

Wow, totally not intuitive, especially when lower case works for days and years!  Thanks so much for the very speedy response.  Working as expected now. 

Rachel

[Alex Medved _ConfiForms_]

Hi @rachel sebben 

I do agree, but this is what we have from the platform… and have to live with it

Alex