# Timestamp Format **URL:** \ **Category:** External Collections, Custom Actions & Collections\ **Created:** [November 28, 2021, 10:25am UTC](https://forum.adalo.com/t/timestamp-format/20177 "2021-11-28T10:25:04Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![breadflix.es](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/breadflix.es/32/25243_2.png) [@breadflix.es](https://forum.adalo.com/u/breadflix.es)\ **Post date:** [November 28, 2021, 10:25am UTC](https://forum.adalo.com/t/timestamp-format/20177/1 "2021-11-28T10:25:04Z")
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? ![Screenshot 2021-11-28 at 11.13.30](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/0/0310340deb59eca9f2bf4f536d192a908a3521ce.png) ---
**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\ **Post date:** [November 30, 2021, 3:13pm UTC](https://forum.adalo.com/t/timestamp-format/20177/2 "2021-11-30T15:13:34Z")
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. ---
**Author:** ![AndreasAyoCruz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/andreasayocruz/32/728_2.png) [@AndreasAyoCruz](https://forum.adalo.com/u/AndreasAyoCruz)\ **Post date:** [June 17, 2022, 11:35am UTC](https://forum.adalo.com/t/timestamp-format/20177/3 "2022-06-17T11:35:05Z")
> [@Victor](#): > > 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 ---
**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\ **Post date:** [June 21, 2022, 9:29am UTC](https://forum.adalo.com/t/timestamp-format/20177/4 "2022-06-21T09:29:28Z")
Hi @AndreasAyoCruz, I am not sure I understand your question. Best, Victor ---
**Author:** ![AndreasAyoCruz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/andreasayocruz/32/728_2.png) [@AndreasAyoCruz](https://forum.adalo.com/u/AndreasAyoCruz)\ **Post date:** [June 21, 2022, 9:31am UTC](https://forum.adalo.com/t/timestamp-format/20177/5 "2022-06-21T09:31:37Z")
> [@AndreasAyoCruz](#): > > what does the settings look like? thx I have already solved ![Snímka obrazovky 2022-06-21 o 11.31.13](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/a/2/a22d7516635e13cf5993e955b9594131751775cf.png) ---
**Author:** ![JL\_LJ](https://avatars.discourse-cdn.com/v4/letter/j/f08c70/32.png) [@JL\_LJ](https://forum.adalo.com/u/JL_LJ)\ **Post date:** [June 21, 2022, 9:42am UTC](https://forum.adalo.com/t/timestamp-format/20177/6 "2022-06-21T09:42:12Z")
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](https://forum.adalo.com/t/edit-record-from-xano/27702/11): > > 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 When I the take a look in Xano the date+time is wrong. 86400 is the number of seconds in a day and 1000 is to convert to XANO miliseconds format ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/8/7/87179ef1bb58fb92eb6680ff55cf5a61acfd3b92.png) Date in XANO is UTC, Date in Adalo, is your App/Browsers location Date ---
**Author:** ![App\_Up2](https://avatars.discourse-cdn.com/v4/letter/a/ba9def/32.png) [@App\_Up2](https://forum.adalo.com/u/App_Up2)\ **Post date:** [September 29, 2025, 4:19pm UTC](https://forum.adalo.com/t/timestamp-format/20177/7 "2025-09-29T16:19:35Z")
When you say “Note Reminder” is this the “Starting Time”? Let’s say I clocked-in at 12PM and clocked-out at 7PM, I should have a total of 7-hours. How can I get this? Thanks much