topic Re: JIRA createdAfter date gets wrong formatted in Connectivity & Data Prep

JIRA createdAfter date gets wrong formatted

rbecher — Fri, 02 Apr 2021 08:05:54 GMT

Hi,

I tried to set a date as parameter with the wizard (createdAfter=15-11-2016) and date is converted from the connector to the wrong format (2016.11.15) and passed to JIRA and it gives me the following error:

{"errorMessages":["Datumswert '2016.11.15' fÃ¼r Feld 'created' ist ungÃ¼ltig. GÃ¼ltige Formate umfassen: 'jjjj/MM/tt HH:mm', 'jjjj-MM-tt HH:mm', 'jjjj/MM/tt', 'jjjj-MM-tt' oder ein Zeitraumformat wie '-5t', '4w 2t'."],"errors":{}}

If I use the right JIRA format in URL instead (createdAfter=2016/11/15) the connector doesn't recognize it as date:

The following parameter validation errors were found: createdAfter: Cannot parse '2016/11/15' as a date,

expected format is DD-MM-YYYY - Die Zeichenfolge wurde nicht als gÃ¼ltiges DateTime erkannt.

Any idea for a workaround?

Version

2.2.0.20135

- Ralf

Re: JIRA createdAfter date gets wrong formatted

Anonymous — Wed, 15 Nov 2017 15:47:21 GMT

Hi - This looks like a bug unfortunately. It does appear that it is has been fixed for the upcoming release though.

Not sure if there is a good workaround, I assume it's happening because your windows box is set to use YYYY.MM.DD so changing this to use DD/MM/YYYY should fix it but you probably don't want to do this. However - it would be useful if you could at least validate this is the cause in case we need to investigate more deeply.

Re: JIRA createdAfter date gets wrong formatted

rbecher — Wed, 15 Nov 2017 16:25:39 GMT

Hi Chris,

this was my guessing too. Unfortunately, I don' t have the rights to change the settings on the server..

- Ralf