# Please help with due date/time

**URL:** <https://forum.adalo.com/t/please-help-with-due-date-time/28560>\
**Category:** Get Help\
**Created:** [June 22, 2022, 4:09am UTC](https://forum.adalo.com/t/please-help-with-due-date-time/28560 "2022-06-22T04:09:58Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![MikesClub](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/mikesclub/32/12754_2.png) [@MikesClub](https://forum.adalo.com/u/MikesClub)\
**Post date:** [June 22, 2022, 4:09am UTC](https://forum.adalo.com/t/please-help-with-due-date-time/28560/1 "2022-06-22T04:09:58Z")

</div>

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 without time, so “start of today” doesn’t actually mean anything.

Then I tried using a date/time field. The problem here is that whenever I choose a date in a date/time field, the time always defaults to 00:00. I have to change the time component every time I set a due date. I need to make the “6 PM” a default.

How do I set this up so that “in 2 days” always means “in 2 days at 6 PM”, or “on July 14” always means “on July 14 at 6 PM”?

---

<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:** [June 22, 2022, 5:59am UTC](https://forum.adalo.com/t/please-help-with-due-date-time/28560/2 "2022-06-22T05:59:42Z")

</div>

Hi @MikesClub,

I’m guessing what you need is this :

![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/8/3/83e3f9a07eec6e7ad1e1359ca470a3aa6314cd0c.png)

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/8/1/81b8bb10d846fc98f9a745011dc9383ba57c4a0d.png)

`Formula : 2 days from now ( according to what you need ) + 0.75000006 or 2 days from now ( according to what you need ) + (18*0.04166667)`

Found details from this post posted by Patrick! :

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

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/d/7/d732ea012ec5098ed9f50257de75f7eef3f1aa1c.png)

Not a expert with dates 🙂 Hope I’m correct!

Maybe others can add information here? 🙌

Thank you

---

<div class="post-metadata">

**Author:** ![Rios](https://avatars.discourse-cdn.com/v4/letter/r/a587f6/32.png) [@Rios](https://forum.adalo.com/u/Rios)\
**Post date:** [June 27, 2022, 1:32pm UTC](https://forum.adalo.com/t/please-help-with-due-date-time/28560/3 "2022-06-27T13:32:37Z")

</div>

Does anyone already have the solution for custom start and end date control?

needed for use in contract management.

---

<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:** [June 27, 2022, 6:21pm UTC](https://forum.adalo.com/t/please-help-with-due-date-time/28560/4 "2022-06-27T18:21:14Z")

</div>

Hi @Rios,

Welcome to the community 🥳

What you need to do? Can you give us some more information with a example?

Thank you

---

<div class="post-metadata">

**Author:** ![Rios](https://avatars.discourse-cdn.com/v4/letter/r/a587f6/32.png) [@Rios](https://forum.adalo.com/u/Rios)\
**Post date:** [June 27, 2022, 6:47pm UTC](https://forum.adalo.com/t/please-help-with-due-date-time/28560/5 "2022-06-27T18:47:18Z")

</div>

I need to know the deadline of a contract.  
Example: the contract starts on 06/25/2022  
lasts for 30 months

What I need to know is, what is the end date? xxxx

thanks @dilon_perera

---

<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:** [June 28, 2022, 7:35pm UTC](https://forum.adalo.com/t/please-help-with-due-date-time/28560/6 "2022-06-28T19:35:43Z")

</div>

You need two Date Properties. One for Start Date and End Date. And on your create contract action you can add start date to the end date and add +30 or to be dynamic you can add a input and add that instead of 30. You can do the same thing with forms too!

Check this video! : [end date add value.mp4 - Google Drive](https://drive.google.com/file/d/1317nsKZCvKGDAaRAjB1N-xEjrgjk-Jcv/view?usp=sharing)

---

<div class="post-metadata">

**Author:** ![Rios](https://avatars.discourse-cdn.com/v4/letter/r/a587f6/32.png) [@Rios](https://forum.adalo.com/u/Rios)\
**Post date:** [July 4, 2022, 7:37pm UTC](https://forum.adalo.com/t/please-help-with-due-date-time/28560/7 "2022-07-04T19:37:22Z")

</div>

@Dilon  
Hi, I need to add months.  
Today’s date 7/4/2022 and the end date 30 months later

The resulting date is 1/4/2025 - Saturday, January 4, 2025

---

<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:** [July 5, 2022, 6:41am UTC](https://forum.adalo.com/t/please-help-with-due-date-time/28560/8 "2022-07-05T06:41:02Z")

</div>

I think you need to add 912.501.

![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/d/4/d4029c674ad177064d06faf52e105bf5749cf706.png)

![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/b/f/bfbfe20a7e5b50aea238f03cfc017821461cbd4c.png)

---

<div class="post-metadata">

**Author:** ![Rios](https://avatars.discourse-cdn.com/v4/letter/r/a587f6/32.png) [@Rios](https://forum.adalo.com/u/Rios)\
**Post date:** [July 14, 2022, 8:20pm UTC](https://forum.adalo.com/t/please-help-with-due-date-time/28560/9 "2022-07-14T20:20:44Z")

</div>

> [@Dilon](#):
>
> 912.501

@Dilon  
Hi, I was testing this idea of ​​yours, if it is with a defined date for all cases it works, but I need it with several amounts of months (the choice of the amount of month is free)  
I can choose 12 months, 15 months, 16 months, 20 months, 25 months, 30 months…  
the customer who will put in the input field the number of months he wants to know the final date.

the problem that the months have different days.  
Has month of 28 days, 29 days, 30 days, 31 days

would have to get by dates and not by number of days

---

<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:** [July 24, 2022, 8:20pm UTC](https://forum.adalo.com/t/please-help-with-due-date-time/28560/10 "2022-07-24T20:20:50Z")

</div>

Closed on July 24, 2022, 8:20pm UTC

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