Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Product Q&A
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Dates are not upload from Excel Correctly

patrick_sullivan
patrick_sullivan
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
October 5, 2023

I have tried bulk uploading tickets from excel but I am running into trouble with my start and due dates

I have tried it multiple ways. When I enter dd/mmm/yy, is says the the dates cannot be parsed. however when I switch to mm/dd/yyyy, the dates will load, but every month is changed to January.

 

Does anyone know what could possibly be happening?

Answer
Watch
Like Be the first to like this
153 views

1 answer

0 votes
G subramanyam
G subramanyam
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
October 5, 2023

Hi @patrick_sullivan welcome to the Atlassian community.

I'm in the thinking that, you have already considered the below:

  • Jira Date field settings
  • Abbreviated the month ("Jan" for "January)
  • Tested with few Jira tickets instead of bulk

The Jira Importers plugin allows you to import your data from a comma-separated value (CSV) file. Please give it a shot.

Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events

    See all events