Timestamp Format

[breadflix.es]

Hi there, I need to send a date to Xano, but I have a problem with timestamp format.
@Xano works in milliseconds (ie: 1604959474000) but it doesn’t work.
I’ve tried a lot of formats and nothing…
Does anyone know what the correct format is?

[Victor]

Hi Enrique @breadflix.es,

If you have a DateTime property, you can take the value from it and multiply it by 86 000 000 (which is 24 * 60 * 60 * 1000).
Adalo stores DateTimes and Dates as days since 1/1/1970, so this multiplication will get you the value in milliseconds .

Best regards, Victor.

[AndreasAyoCruz]

@Victor

If you have a DateTime property, you can take the value from it and multiply it by 86 000 000 (which is 246060*1000).
Adalo stores DateTimes and Dates as days since 1/1/1970, so this multiplication will get you the value in milliseconds .

Best regards, Victor.

what does the settings look like? thx

[Victor]

Hi @AndreasAyoCruz,

I am not sure I understand your question.

Best,
Victor

[AndreasAyoCruz]

@AndreasAyoCruz

what does the settings look like? thx

I have already solved

[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