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.