You are viewing limited content. For full access, please sign in.

Question

Question

Date/Time field not showing up properly in Excel

asked on May 6, 2021

Hello,

We added a Date/Time field to a template for a customer today, but when downloading a metadata report, that Date/Time field doesn't transfer over properly. Screenshot below:

The creation date gets switched to military time, which is fine, but the Initial Order Date isn't accurate whatsoever. We could simply change this Initial Order Date field to a text field as they're not going to be sorting by it so we don't necessarily care how Excel formats it, but I'm still curious why the creation date transfers fine but this Date/Time field isn't correct in Excel. Any insight? Feels like something simple that I'm missing for some reason.

0 0

Answer

SELECTED ANSWER
replied on May 6, 2021

It's showing the timestamp in UTC. If you are using the desktop client, this is fixed in version 11 (bug# 304263).

1 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.