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

Question

Question

Generate Report Date Format

asked on February 28, 2024

When I generate a metadata report from the repository the creation date field result is something like this:

 

3/21/2023 1:12:04 PM

 

This format is not recognized in Excel.  Is there a setting I can change which will make the date field recognized by Excel?

0 0

Replies

replied on February 28, 2024

It looks like you are in Canada, so I'm guessing Excel is trying to parse that value based on your local machine's settings of d/m/y date formats? We do take into account locale settings when we generate the file, but maybe web client thinks you want dates in m/d/y. Can you check your browser settings, or the account settings if you are on Cloud?

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

Sign in to reply to this post.