# Date data type in Adalo

**URL:** <https://forum.adalo.com/t/date-data-type-in-adalo/10847>\
**Category:** External Collections, Custom Actions & Collections\
**Created:** [March 31, 2021, 5:22pm UTC](https://forum.adalo.com/t/date-data-type-in-adalo/10847 "2021-03-31T17:22:02Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![keerthanmahesh](https://avatars.discourse-cdn.com/v4/letter/k/d78d45/32.png) [@keerthanmahesh](https://forum.adalo.com/u/keerthanmahesh)\
**Post date:** [March 31, 2021, 5:22pm UTC](https://forum.adalo.com/t/date-data-type-in-adalo/10847/1 "2021-03-31T17:22:03Z")

</div>

Hey everyone, what format is the Date type in Adalo stored as? Is it Unix? And when we use it in our custom actions, what format does it return?

From our testing we are getting the following return values: “18723.49202546296”, “18754.49202546296", “in 19 hours”, “in 5 hours”. These are extremely vague values. Please guide me on this issue.

---

<div class="post-metadata">

**Author:** ![James\_App\_Maker](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/james_app_maker/32/37288_2.png) [@James\_App\_Maker](https://forum.adalo.com/u/James_App_Maker)\
**Post date:** [March 31, 2021, 5:27pm UTC](https://forum.adalo.com/t/date-data-type-in-adalo/10847/3 "2021-03-31T17:27:28Z")

</div>

Hi Keerthan,

I would submit a support ticket to know about this.

> **[Submit a Support Ticket](https://info.adalo.com/submit-a-support-ticket)**
>
> Submit a support ticket for the Adalo Support team to help resolve issues, troubleshoot bugs, and offer app guidance.

_Please do not tag Adalo Staff for any reason as stated in Adalo’s Community Guidelines._

---

<div class="post-metadata">

**Author:** ![keerthanmahesh](https://avatars.discourse-cdn.com/v4/letter/k/d78d45/32.png) [@keerthanmahesh](https://forum.adalo.com/u/keerthanmahesh)\
**Post date:** [March 31, 2021, 5:28pm UTC](https://forum.adalo.com/t/date-data-type-in-adalo/10847/4 "2021-03-31T17:28:08Z")

</div>

Thank you @James_App_Maker

---

<div class="post-metadata">

**Author:** ![James\_App\_Maker](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/james_app_maker/32/37288_2.png) [@James\_App\_Maker](https://forum.adalo.com/u/James_App_Maker)\
**Post date:** [March 31, 2021, 5:30pm UTC](https://forum.adalo.com/t/date-data-type-in-adalo/10847/5 "2021-03-31T17:30:03Z")

</div>

I’m glad I could help you! 🙂

Also I don’t want you getting suspended or banned from the forum so that’s why I’m asking not to tag Adalo Staff.

---

<div class="post-metadata">

**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:** [April 1, 2021, 1:31pm UTC](https://forum.adalo.com/t/date-data-type-in-adalo/10847/6 "2021-04-01T13:31:21Z")

</div>

Hi @keerthanmahesh,

The date is stored as number of days since 01/01/1970 (integer part) and the “fraction” of the day (fractional part).  
So to add one day you can simply increase the date value by 1.  
Date is stored in UTC and is “adjusted” to the user’s time zone when displayed. E.g. if user sets 12:00 AM, and he is in UTC+3, the real date stored will be day before 9 PM.

Date can be _presented_ to users with different formatting options: relative, date + time, etc. This is done via the settings of the magic text (where you put date property).

Best regards, Victor.