Hi there,
I'm trying to import dates into JIRA from a CSV file using this format:
dd/mmm/yy hh:mm
However every time it shows an error confirming the dates cant be accessed. I was advised on a help board that i need to ensure the Date format in JIRA matches that in my CSV, however when i go into advanced settings - Look and feel - date & time...there is no option for me to look at the existing date format or even change it.
Can you please advise what i do next?
Thanks,
Andy
I've never seen that error message before, but here are a couple things to try and troubleshoot:
Thanks Alex i have since worked out where i was going wrong....i was using lowercase 'mmm' which represents minutes instead of uppercase 'MMM' which represents months!!!
All sorted thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Andrew & Alex - Could you help with this? I'm trying to import with Due Dates via CSV import using the default date format and haven't had success yet:
dd/MMM/yy h:mm a
I've opened the CSV in Notepad and tried the following formats:
21/may/19 1:00 a
21/MAY/19 1:00 a
What am I missing? Thanks in advance!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Margaret Wehr have you tried this format in your CSV?
21/May/19 1:00 AM
I think that the "MMM" is case-sensitive, so you need to capitalize the first letter in "May," and I believe that the "a" requires an "AM" or "PM" value instead of just the "a" you have.
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.