Export Excel date is shortened

DD_Chelsea · January 12, 2021, 8:03pm

Hello! good afternoon.

Could you help me to see why the date is being shortened when i export it to excel.

Here is the table with the full date

but when i export it it appears like this:

Do you know why is happening this?

Thanks in advance for the help!

nminchin · January 12, 2021, 8:04pm

Have you checked what format you’re using to display the date columns in Excel? It’s probably set to just show the date

DD_Chelsea · January 12, 2021, 8:10pm

thanks for the response!

is there a way to show the date and time in the excel file?

nminchin · January 12, 2021, 8:15pm

Yes, you need to use a custom format. It’s a bit stupid that they don’t give you a datetime option

DD_Chelsea · January 12, 2021, 8:17pm

Thanks for the help!

problem solved

Have a good day!