Issue Summary

You can get transition related fields from the issues when using Jira Cloud for Sheets, including the date for the transition by using the property Status Transition.date.

Currently, if you use the JIRA JQL function to retrieve results, the Status Transition.date is returned on the wrong format (its database format).

Steps to Reproduce

• Access the Jira Cloud for Sheets app;
• Enable the Jira function;
• Perform a search as the following:

  =JIRA("key= AV-6399", "key, transition.date")
  

Expected Results

The date format of the transition.date column will follow the other dates.

Actual Results

The format returned is the one as stored in the database:

Workaround

Use the JQL method to retrieve the results instead. Currently, the transition.date format is correct when using that method: