HELP -dates on csv import

[andrew Tobias]

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

[Alex Christensen]

I've never seen that error message before, but here are a couple things to try and troubleshoot:

• Are you trying to update Due Dates for issues via CSV import? If so, make sure you have the "Schedule Issues" permission for that project or projects. Not sure if that permission affects the CSV import or not, but you normally have to have that permission to view/edit an issue's Due Date.
• When using the import wizard, what are you entering in the "Date format" field? By default, this field uses the format dd/MMM/yy h:mm a, so if you have a different format in your CSV file, you need to update this field in the import wizard (or update your CSV file to match this format)

[andrew Tobias]

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.

[Margaret Wehr]

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!

[Alex Christensen]

@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.