# Tomorrow's Date is between Two Dates

**URL:** <https://community.glideapps.com/t/tomorrows-date-is-between-two-dates/55755>\
**Category:** Ask for Help\
**Created:** [December 15, 2022, 7:58am UTC](https://community.glideapps.com/t/tomorrows-date-is-between-two-dates/55755 "2022-12-15T07:58:04Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [December 15, 2022, 7:58am UTC](https://community.glideapps.com/t/tomorrows-date-is-between-two-dates/55755/1 "2022-12-15T07:58:05Z")

</div>

Continuing the discussion from [Today is between Two Dates](https://community.glideapps.com/t/today-is-between-two-dates/40834/2):

Hello, i’m come again with this problem. as solution above,  
To find “Today” who on leave.

but now i need to add “tomorrow” who is on leave.

I’m using same method as you suggest but I find something wrong with the tomorrow’s date .  
I think there’s a different between now() and today().

to find tomorrow’s date. I’m using math column “now()+1”

but when come to single if-then-else column.

- If Start Date is after tomorrow’s date, then false
- If End Date is before tomorrow’s date, then false
- Else true

it still showing **false** for the start date is tomorrow’s date.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 15, 2022, 8:11am UTC](https://community.glideapps.com/t/tomorrows-date-is-between-two-dates/55755/2 "2022-12-15T08:11:07Z")

</div>

My guess would be that there are times included with your dates that are tripping things up.

For example, let’s say “Now” is December 15th at 3pm.  
Therefore, tomorrow (Now + 1) will be December 16th at 3pm.  
If your Start Date is December 16th at 4pm, then it will return false.

In this case, you might be better to first convert all your dates to integers. That will eliminate the time as a factor.

So, to get today, use the following:

```auto
Year(Now) * 10000
+ Month(Now) * 100
+ Day(Now)

```

Tomorrow will just be the above, plus 1.

So that will give you:

- Today: 20221215
- Tomorrow: 20221216

Then use the same math formula on your dates, and change the if-then-else to do a numerical comparison:

- If Start is greater than Tomorrow, then null
- If End is less than Today, then null
- Else true

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [December 15, 2022, 8:12am UTC](https://community.glideapps.com/t/tomorrows-date-is-between-two-dates/55755/3 "2022-12-15T08:12:44Z")

</div>

Meaning if in this case, the start date , end date also need to use the formula right ?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 15, 2022, 8:13am UTC](https://community.glideapps.com/t/tomorrows-date-is-between-two-dates/55755/4 "2022-12-15T08:13:41Z")

</div>

Yes, correct.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [December 16, 2022, 8:13am UTC](https://community.glideapps.com/t/tomorrows-date-is-between-two-dates/55755/5 "2022-12-16T08:13:55Z")

</div>

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