How to handle date data with different date format when batch import from csv file

Question

Hi,

I got a CSV file with different format date data,like"yyyy-MM-dd" and "yyyy-MM-dd hh:mm:ss".Now,I created two extra fields to my issues,one "Date Picker",the other "Date Time Picker".I want to map "yyyy-MM-dd" date data into "Date Picker" field,"yyyy-MM-dd hh:mm:ss" go into "Date Time Picker" field.The problem is Jira can only specify one date format when I import issues from a CSV file.When a date with a date format not align to the specified format,a warning will be produced and that date data will be get lost.Is there a way for me to specify different conversion formats for different dates.

Jens Schumacher - Released_so · Answer

You could try to format all in the same way. You could run GPT over your file and asked it to re-write the date without the timestamp, or write a script with a regular expression to add the time format.

Lin, Lijun · Answer

Yes,I have tried the format "yyyy-MM-dd",and for "yyyy-MM-dd hh:mm:ss" data, i just got "yyyy-MM-dd" part, the "hh:mm:ss" part lost.

Mohanraj Thangamuthu · Answer

Hello, have you tried the format : yyyy-MM-dd already ?

Please refer to this doc once.