Date Not Matching - Looks like a BUG

[AjitKumar]

Hello Everyone

This is strange.

If I try to download any of the logs from Dashboard in the CSV format - The date will not match the event date.

The date captured looks unrealistic.

[DarrenOC]

Hi @AjitKumar 

Just tried via my dashboard and I'm getting different behaviour.  Is Excel formatting the data differently?  What does the data show if you open as a text file?

[DarrenOC]

even if I set the data types to similar as yours and Add First Seen and Last Seen the formatting looks correct

[AjitKumar]

Hi@DarrenOC

Formatting is fine.

How about the Date?

Ex.

01/05/2021

01/05/2029

[DarrenOC]

I clearly can't multitask - or read by the looks of it.  Yep the First Seen data is corrupt on my output also.

You raised with support?

[CiscoAl]

You just need to change the date format to US mm/dd/yyyy tt:tt format

https://documentation.meraki.com/General_Administration/Cross-Platform_Content/Using_Exported_Client...