Uploading Date through Bulk Upload results in a date two days back

[jsavath]

Hi

Running into an issue with a csv bulk upload. The Due Dates dates are uploading but show as two days in the past. The csv upload file has "23-Jul-24" format and I am selecting the below date format. 

I have already checked the timezone and the system and user timezone are the same. Thank you!

[Hannes Obweger - JXL for Jira]

Hi @jsavath

welcome to the community!

Hm, my guess would also very much be on a time zone issue. Have you reached out to Atlassian Support about this already?

I very much agree that this should be possible in Jira natively, but just to put it out there: If you're looking for an immediate resolution and are open to solutions from the Atlassian Marketplace, you'll have options available. I'll add more information below.

Best,

Hannes

[Hannes Obweger - JXL for Jira]

... and just to expand on my last point: If you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also allows bulk editing your issue fields via copy/paste. This works within JXL, but also between JXL and pretty much any other app, including Excel or Google Sheets, like so:

You can update any number of issues in one action, so you should be done with your work in no time. Just make sure you're pasting the due dates into the correct set of issues.

(I should add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.)

Any questions just let me know!

[jsavath]

Thank you @Hannes Obweger - JXL for Jira .

We had confirmed the user timezone and system timezone are in the same location but are still running into this issue. At most, the timezone issue would be 24 hour max and not two days