# Subtract days from a date

**URL:** <https://forum.adalo.com/t/subtract-days-from-a-date/10922>\
**Category:** Get Help\
**Created:** [April 2, 2021, 2:24pm UTC](https://forum.adalo.com/t/subtract-days-from-a-date/10922 "2021-04-02T14:24:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![miticobeppe](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/miticobeppe/32/18933_2.png) [@miticobeppe](https://forum.adalo.com/u/miticobeppe)\
**Post date:** [April 2, 2021, 2:24pm UTC](https://forum.adalo.com/t/subtract-days-from-a-date/10922/1 "2021-04-02T14:24:34Z")

</div>

Hello to all,

I have a question, which I can’t find an answer to.

How can I subtract days from a date inherited by the user?

I’ll give you an example: the user uses the date picker to choose a date.

once this date has been confirmed, the update is performed to save this date.  
Later if I then wanted to subtract 10 days from this date which formula should I use?

User: 4/20/2021 must become 4/10/2021.

I specify that the date picker is of type: Date & Time  
And another Date & Time will be the field that will receive the new date subtracted by 10 days.

It’s possible? can you help me?  
Thank you all

---

<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 2, 2021, 2:39pm UTC](https://forum.adalo.com/t/subtract-days-from-a-date/10922/2 "2021-04-02T14:39:58Z")

</div>

Hi @miticobeppe,

The date in Adalo is stored in the format like: 18566.24152, where integer is number of days since 1/1/1970, and fraction is a “part of the day”.  
So if you simply deduct 10 from the date, you’ll get the result you want.

Best,  
Victor

---

<div class="post-metadata">

**Author:** ![KBass](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/kbass/32/7590_2.png) [@KBass](https://forum.adalo.com/u/KBass)\
**Post date:** [April 2, 2021, 2:58pm UTC](https://forum.adalo.com/t/subtract-days-from-a-date/10922/3 "2021-04-02T14:58:13Z")

</div>

Another way to do this is to subtract or add days in the database.

Choose the date picker and add -10 or +10 to the end of the date picker.

![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/1/1eb9bdc1f068fba68163ffb11b73e2761e344a49.png)

---

<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:** [April 12, 2021, 2:58pm UTC](https://forum.adalo.com/t/subtract-days-from-a-date/10922/4 "2021-04-12T14:58:25Z")

</div>

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