# Date + Number - Why does this not work in Adalo

**URL:** <https://forum.adalo.com/t/date-number-why-does-this-not-work-in-adalo/21918>\
**Category:** Get Help\
**Created:** [January 11, 2022, 3:39pm UTC](https://forum.adalo.com/t/date-number-why-does-this-not-work-in-adalo/21918 "2022-01-11T15:39:00Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![jmb2021](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/jmb2021/32/11772_2.png) [@jmb2021](https://forum.adalo.com/u/jmb2021)\
**Post date:** [January 11, 2022, 3:39pm UTC](https://forum.adalo.com/t/date-number-why-does-this-not-work-in-adalo/21918/1 "2022-01-11T15:39:00Z")

</div>

Hi,

I am trying to organize a few screen on adalo for subscriptions.

My problem:

User can pay a month or a year: But why does this not work - User has a property Subscription expiry date… And i am using Todays Date +365 (days) to add to the expiry field. It does not add anything to the field.

I would have assumed you could set a date field using this method,

do any of you have anyway of doing this or are any of you encountering the same problem?

I would love some solutions from the adalo community.

Best

Jordan

---

<div class="post-metadata">

**Author:** ![njimmy10](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/njimmy10/32/23489_2.png) [@njimmy10](https://forum.adalo.com/u/njimmy10)\
**Post date:** [January 11, 2022, 5:03pm UTC](https://forum.adalo.com/t/date-number-why-does-this-not-work-in-adalo/21918/2 "2022-01-11T17:03:32Z")

</div>

Hello, Try using instead of current time \> use 1 year from now would be better

---

<div class="post-metadata">

**Author:** ![charleshope](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/charleshope/32/25088_2.png) [@charleshope](https://forum.adalo.com/u/charleshope)\
**Post date:** [January 12, 2022, 9:07am UTC](https://forum.adalo.com/t/date-number-why-does-this-not-work-in-adalo/21918/3 "2022-01-12T09:07:00Z")

</div>

Maybe this post will help:

> [@Using Time/Duration in custom formulas](https://forum.adalo.com/t/using-time-duration-in-custom-formulas/18511/4):
>
> Adalo calculates dates using [UNIX timestamps](https://www.unixtimestamp.com/index.php) which traditionally are the number of seconds since UNIX was implemented back in 1970. The only difference is that Adalo handles these in days, meaning that if a typical UNIX timestamp is 1634310307 (number of seconds), the day equivalent in Adalo is basically just a moved decimal point: 16343.10307. Knowing this you can create records in a collection called “Duration” that have the duration in this format and then add the selected duration from a dr…

---

<div class="post-metadata">

**Author:** ![jmb2021](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/jmb2021/32/11772_2.png) [@jmb2021](https://forum.adalo.com/u/jmb2021)\
**Post date:** [January 12, 2022, 8:22pm UTC](https://forum.adalo.com/t/date-number-why-does-this-not-work-in-adalo/21918/4 "2022-01-12T20:22:57Z")

</div>

Thanks, this worked for me, somehow i did not think of this! i have been using it in other places in the app lol.

---

<div class="post-metadata">

**Author:** ![jmb2021](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/jmb2021/32/11772_2.png) [@jmb2021](https://forum.adalo.com/u/jmb2021)\
**Post date:** [January 12, 2022, 8:27pm UTC](https://forum.adalo.com/t/date-number-why-does-this-not-work-in-adalo/21918/5 "2022-01-12T20:27:12Z")

</div>

Thanks that is a helpful post for anyone out there,

best

---

<div class="post-metadata">

**Author:** ![njimmy10](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/njimmy10/32/23489_2.png) [@njimmy10](https://forum.adalo.com/u/njimmy10)\
**Post date:** [January 12, 2022, 9:01pm UTC](https://forum.adalo.com/t/date-number-why-does-this-not-work-in-adalo/21918/6 "2022-01-12T21:01:05Z")

</div>

Glad it did

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [January 22, 2022, 9:01pm UTC](https://forum.adalo.com/t/date-number-why-does-this-not-work-in-adalo/21918/7 "2022-01-22T21:01:21Z")

</div>

Closed on January 22, 2022, 9:01pm UTC

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.
