Timestamp Format

[JL_LJ]

Hi,
You need to convert to UNIX XANO format which is in milliseconds if you don’t want to do it in XANO.

I have wrote that in another topic:

Edit record from Xano

Hi @JL_LJ The problem when I create a record in Adalo with a date+time picker the date is not displayed correctly in xano. I will show you an example with screenshots: Let say I want to create a record with the following date/time: Tue, May 31, 2022: 7:19 PM. In the screenshot you also see how it is formatted [image] [image] When I the take a look in Xano the date+time is wrong. [image] [image]

86400 is the number of seconds in a day and 1000 is to convert to XANO miliseconds format

Date in XANO is UTC, Date in Adalo, is your App/Browsers location Date