WinCC Audit Date/Time Export

I have a problem when using WinCC Audit 7.5 SP2, when I export my Audit Trail using the Audit Viewer to CSV the Date_Time column shows a strange number (i.e. 40.12.22) instead of showing the actual date/time. Any ideas why?

Note, it shows correctly in the Audit Viewer, but not in the export

Hi Neogazz_Alpha!

Could you send a screenshot? Which version are you using exactly? How is configured?

See attached screenshot of the CSV export, which shows a strange date/time format.

I see within the Audit Viewer the Date/Time looks fine, also see attached.

I have configured using 'Local Time Zone', is there anything else I need to check?

Hello Neogazz_Alpha

can you please open the File with a Text editor and not with Excel (please do also not save this file with excel).

Which value do you see here?

Bye Murof

Hi Murof, do you mean can I open the exported CSV file with a text editor like notepad?

Problem solved, as per attached screenshot the problem was an incorrect setting within excel.

For the Date_Time field "Custom" formatting must be used.