Dear community
I have download CSV files from the database. however the date & time format is not in format that I expected.
Is there any work around to change “2021-10-27T01:29:45.000Z” into “27-10-2021 01:29:45” in excel without using integromat to list record because this action will burn my operation limit
Thank you.
Hi @Aizuddin 
I tested to do like format cells in that Date and time property but didn’t work. But I found a different solution.
You can create a text property and set the update action that item > created text property to Date & Time > Current time
And change the Date Format to Date / Time.
Then it’s updating like this.
Then download the CSV file. And when you open your CSV file you can see like this in your text property.
So adjust that column. Then you will see like this.
Then you don’t see the am or pm. So select that column and click Ctrl+1 or right click and select Format Cells.
Then you will get this screen.
In there select this one.
Then you are done and the result is this.
Excel
Adalo Database
Thank you
