I’ve never had issues integrating into excel, but I now the date format is coming in like this and I can’t figure out how to fix it. Please help!
0022-01-16T00:00:00.000Z |
I’ve never had issues integrating into excel, but I now the date format is coming in like this and I can’t figure out how to fix it. Please help!
0022-01-16T00:00:00.000Z |
Best answer by john.desborough
there’s a good blog post on this here at this link
One thing to note is that date fields are collected with a time stamp of midnight (hence the T00:00:00Z) which is UTC time
you will have to update how you deal with the date in Excel through formatting..
cheers
des
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.