# How do you use the "today" item
**URL:** https://community.glideapps.com/t/how-do-you-use-the-today-item/43133
**Category:** Ask for Help
**Created:** [June 16, 2022, 2:52am UTC](https://community.glideapps.com/t/how-do-you-use-the-today-item/43133 "2022-06-16T02:52:41Z")
**Posts on this page:** 18
**Page:** 1
### Author:  [@moshi](https://community.glideapps.com/u/moshi)
#### Post date: [June 16, 2022, 2:52am UTC](https://community.glideapps.com/t/how-do-you-use-the-today-item/43133/1 "2022-06-16T02:52:41Z")
Is this a glitch or am I just using this wrong?
The date is after today, why isn’t it outputting true?
---
### Author:  [@JuanM](https://community.glideapps.com/u/JuanM)
#### Post date: [June 16, 2022, 3:14am UTC](https://community.glideapps.com/t/how-do-you-use-the-today-item/43133/2 "2022-06-16T03:14:55Z")
you are probably using a different format than indicated, how did you get the date in your pickup\_date column?
---
### Author:  [@moshi](https://community.glideapps.com/u/moshi)
#### Post date: [June 16, 2022, 3:22am UTC](https://community.glideapps.com/t/how-do-you-use-the-today-item/43133/3 "2022-06-16T03:22:04Z")
> [@JuanM](#):
>
> pickup\_date column?
Here is the format. I tried almost every configuration. Not sure why it’s doing this
---
### Author:  [@JuanMa](https://community.glideapps.com/u/JuanMa)
#### Post date: [June 16, 2022, 3:24am UTC](https://community.glideapps.com/t/how-do-you-use-the-today-item/43133/4 "2022-06-16T03:24:36Z")
you are probably using a different format than indicated, how did you get the date in your pickup\_date column?
---
### Author:  [@moshi](https://community.glideapps.com/u/moshi)
#### Post date: [June 16, 2022, 3:25am UTC](https://community.glideapps.com/t/how-do-you-use-the-today-item/43133/5 "2022-06-16T03:25:36Z")
What would the correct format/configuration be? I tried almost everyone.
> [@moshi](#):
>
> Here is the format. I tried almost every configuration. Not sure why it’s doing this
>
> 
---
### Author:  [@moshi](https://community.glideapps.com/u/moshi)
#### Post date: [June 16, 2022, 3:28am UTC](https://community.glideapps.com/t/how-do-you-use-the-today-item/43133/6 "2022-06-16T03:28:52Z")
I’m considering creating a template column where I replace the variable with the NOW function, then just compare those two columns instead, but I feel like that’s a dirt way of doing it. Shouldn’t the TODAY function suffice?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 16, 2022, 3:32am UTC](https://community.glideapps.com/t/how-do-you-use-the-today-item/43133/7 "2022-06-16T03:32:53Z")
One thing to be aware of is that regardless of which display format you choose, under the hood Glide still stores the full date AND time. You can see that value if you click in the cell.
So possibly that’s whats tripping things up here.
A simple fix might be to use “on or after” instead of just “after”
Working with dates and times in Glide can get very tricky.
---
### Author:  [@JuanM](https://community.glideapps.com/u/JuanM)
#### Post date: [June 16, 2022, 3:33am UTC](https://community.glideapps.com/t/how-do-you-use-the-today-item/43133/8 "2022-06-16T03:33:21Z")
" 2022-06-15T22:31:11.314Z "
this is the correct format in glide, are you manually typing the date in your column?
If the answer is yes, copy this format without quotes or spaces and paste them in your column to test
---
### Author:  [@moshi](https://community.glideapps.com/u/moshi)
#### Post date: [June 16, 2022, 3:37am UTC](https://community.glideapps.com/t/how-do-you-use-the-today-item/43133/9 "2022-06-16T03:37:32Z")
> [@Darren\_Murphy](#):
>
> A simple fix might be to use “on or after” instead of just “after”
That seems like a good idea, thank you for that. The issue is for this app it’s crucial that the comparison has to be for the current day.
---
### Author:  [@moshi](https://community.glideapps.com/u/moshi)
#### Post date: [June 16, 2022, 3:39am UTC](https://community.glideapps.com/t/how-do-you-use-the-today-item/43133/10 "2022-06-16T03:39:47Z")
The user is not submitting the date manually, they are picking from a calendar.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 16, 2022, 3:43am UTC](https://community.glideapps.com/t/how-do-you-use-the-today-item/43133/11 "2022-06-16T03:43:26Z")
> [@moshi](#):
>
> That seems like a good idea, thank you for that. The issue is for this app it’s crucial that the comparison has to be for the current day.
If you want to eliminate the possibility that the time gets in the way, you can use a math column to convert the date to an integer. Something like this:
`Year(Now) * 10000 + Month(Now) * 100 + Day(Now)`
This will give you something like `20220616`, which can be used to do a direct numerical comparison.
---
### Author:  [@moshi](https://community.glideapps.com/u/moshi)
#### Post date: [June 16, 2022, 3:47am UTC](https://community.glideapps.com/t/how-do-you-use-the-today-item/43133/12 "2022-06-16T03:47:18Z")
> [@Darren\_Murphy](#):
>
> Year(Now) \* 10000 + Month(Now) \* 100 + Day(Now)
That sounds great, how would I convert a date into an integer to do the comparison though?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 16, 2022, 3:48am UTC](https://community.glideapps.com/t/how-do-you-use-the-today-item/43133/13 "2022-06-16T03:48:00Z")
Just use the same formula, and use the Date as a replacement instead of Now.
---
### Author:  [@moshi](https://community.glideapps.com/u/moshi)
#### Post date: [June 16, 2022, 3:48am UTC](https://community.glideapps.com/t/how-do-you-use-the-today-item/43133/14 "2022-06-16T03:48:48Z")
Darren you did it again, what a legend man aha
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 16, 2022, 3:51am UTC](https://community.glideapps.com/t/how-do-you-use-the-today-item/43133/15 "2022-06-16T03:51:34Z")
hehe, I only know all this stuff because I pay attention to what guys like [Chuck](https://community.glideapps.com/t/chuck-norris-aka-jeff/26818), [Bob](https://community.glideapps.com/u/robert_petitto) and [Sly](https://community.glideapps.com/u/thinhdinh) say 😉
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 16, 2022, 4:06am UTC](https://community.glideapps.com/t/how-do-you-use-the-today-item/43133/17 "2022-06-16T04:06:35Z")
Bob needs a fun name…
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 16, 2022, 4:07am UTC](https://community.glideapps.com/t/how-do-you-use-the-today-item/43133/18 "2022-06-16T04:07:19Z")
hehe, yes he does. Will give that some thought… 😉
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [June 17, 2022, 4:07am UTC](https://community.glideapps.com/t/how-do-you-use-the-today-item/43133/19 "2022-06-17T04:07:49Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.