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.
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.
Hello, have you tried the format : yyyy-MM-dd already ?
Please refer to this doc once.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.