# Date calculations

**URL:** <https://forum.adalo.com/t/date-calculations/32271>\
**Category:** Get Help\
**Created:** [September 25, 2022, 9:37pm UTC](https://forum.adalo.com/t/date-calculations/32271 "2022-09-25T21:37:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![shadynafie](https://avatars.discourse-cdn.com/v4/letter/s/43a26b/32.png) [@shadynafie](https://forum.adalo.com/u/shadynafie)\
**Post date:** [September 25, 2022, 9:37pm UTC](https://forum.adalo.com/t/date-calculations/32271/1 "2022-09-25T21:37:42Z")

</div>

Hi, I am new to Adalo, and I am pretty excited by its potential, but there is something that is driving me crazy ☹

The user of the app will pick a date using the date picker (I will call it ‘initial date’).  
I want to calculate a new date which is 6 months after the date picked by the user (I will call it ‘due date’), and then put the ‘due date’ in the database.

I know that I should be using a custom formula. but WHERE is Adalo can I do this?

Thank you so much for your help

---

<div class="post-metadata">

**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\
**Post date:** [September 26, 2022, 5:27am UTC](https://forum.adalo.com/t/date-calculations/32271/2 "2022-09-26T05:27:50Z")

</div>

Hi @shadynafie,

Welcome to the community 🥳

These topics will help you!

> [@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…

> [@Please help with due date/time](https://forum.adalo.com/t/please-help-with-due-date-time/28560):
>
> I need help setting a due date with specific time. When someone checks something out from my library, a due date is set and added to the LibraryRecords collection. Borrowed items must be returned by 6 PM on the due date. My problem is how to identify when something is late. First, I tried using a simple date field for the due date. Then I created a list showing anything with a due date before start of today. But I discovered that, when you just use a date field, it always returns date withou…

> [@Adding a javascript snippet](https://forum.adalo.com/t/adding-a-javascript-snippet/9654/11):
>
> Check this : [Add Months in JS.mp4 - Google Drive](https://drive.google.com/file/d/1oFvaiTq_sn6CihtK1G_CbuwkCHL8xSyW/view?usp=sharing)play_button JSplay_button The Component Details Thank you

Thank you

---

<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:** [October 6, 2022, 5:28am UTC](https://forum.adalo.com/t/date-calculations/32271/3 "2022-10-06T05:28:19Z")

</div>

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