-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Low
-
None
-
Affects Version/s: None
-
Component/s: Jira Cloud for Google Sheets
-
None
-
Severity 3 - Minor
Issue Summary
When getting issues trough a JQL query in Jira Cloud for Sheets the time part of date and time fields will be 5 hours behind the value set in the issue.
Steps to Reproduce
- Create a date and time custom field
- Set a value for that field in an issue
- E.g. Mar 04, 2022, 6:00 AM
- Open Google Sheets -> Open the Jira Cloud integration
- Retrieve that issue trough a JQL query
- Set that date and time custom field as a column
Expected Results
The value set in the column related to that custom field reflects the value you see in both the issue view, issue history, and issue navigation in Jira Cloud.
Actual Results
The value is 5 hour behind.
In that example the values is exported as 3/4/2022 1:00:00:
Workaround
Opening the search results from Jira issue navigator to Google Sheets seems to result with the correct values:
