# Tomorrow's Date is between Two Dates Part 2

**URL:** <https://community.glideapps.com/t/tomorrows-date-is-between-two-dates-part-2/58558>\
**Category:** Ask for Help\
**Created:** [February 28, 2023, 2:23am UTC](https://community.glideapps.com/t/tomorrows-date-is-between-two-dates-part-2/58558 "2023-02-28T02:23:20Z")\
**Posts on this page:** 3\
**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:** [February 28, 2023, 2:23am UTC](https://community.glideapps.com/t/tomorrows-date-is-between-two-dates-part-2/58558/1 "2023-02-28T02:23:21Z")

</div>

Continuing the discussion from [Tomorrow's Date is between Two Dates](https://community.glideapps.com/t/tomorrows-date-is-between-two-dates/55755/2):

Hi @Darren_Murphy ,  
I successfully use this formula for tomorrow’s date is between two date until,  
tomorrow date is become 29/2/2023. Suppose tomorrow is 1/3

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/5/051d7b41926e13fc2f6bae5fb1d060235c37c7a8.png)

---

<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:** [February 28, 2023, 2:36am UTC](https://community.glideapps.com/t/tomorrows-date-is-between-two-dates-part-2/58558/2 "2023-02-28T02:36:08Z")

</div>

You should add the 1 before converting it to a number.  
So do it using two columns:

- `Now +1`

 ![CleanShot 2023-02-28 at 10.35.04@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/8/e83a7fabddafe54ab64eec878039d31a57264483.png)

And then convert that to a number.

Actually, you can still use a single column:

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

```

 ![CleanShot 2023-02-28 at 10.37.33@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/0/40edbccce863d21305347d99d9aabc9db07290c1.png)

---

<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:** [March 1, 2023, 2:36am UTC](https://community.glideapps.com/t/tomorrows-date-is-between-two-dates-part-2/58558/3 "2023-03-01T02:36:55Z")

</div>

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