Timestamp Format

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?

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.

what does the settings look like? thx

Hi @AndreasAyoCruz,

I am not sure I understand your question.


I have already solved

1 Like

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:

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