# Filter Data by Date/Time is within Today
**URL:** https://community.glideapps.com/t/filter-data-by-date-time-is-within-today/68362
**Category:** Ask for Help
**Created:** [December 5, 2023, 3:10am UTC](https://community.glideapps.com/t/filter-data-by-date-time-is-within-today/68362 "2023-12-05T03:10:29Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@Clifton\_Crouch](https://community.glideapps.com/u/Clifton_Crouch)
#### Post date: [December 5, 2023, 3:10am UTC](https://community.glideapps.com/t/filter-data-by-date-time-is-within-today/68362/1 "2023-12-05T03:10:29Z")
I’m trying to filter a list of schedule items so that only events for Today are displayed, but I’ve noticed that towards the end of the day, Tomorrow’s events also show up.
I think I must be doing something incorrect with the filter or be misunderstanding how it works.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [December 5, 2023, 3:16am UTC](https://community.glideapps.com/t/filter-data-by-date-time-is-within-today/68362/2 "2023-12-05T03:16:27Z")
Out of curiosity, does your date column have the Respect Time Zone option checked (provided it’s a glide table)?
---
### Author:  [@Clifton\_Crouch](https://community.glideapps.com/u/Clifton_Crouch)
#### Post date: [December 5, 2023, 3:19am UTC](https://community.glideapps.com/t/filter-data-by-date-time-is-within-today/68362/3 "2023-12-05T03:19:27Z")
Thanks Jeff, helping me all over the place haha.
It’s not a Glide table (Google Sheet) so I can’t use it.
I wondered if it had something to do with Time Zones, although I’m in eastern time, but maybe Glide is using somewhere else Internationally as the standard time.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [December 5, 2023, 3:25am UTC](https://community.glideapps.com/t/filter-data-by-date-time-is-within-today/68362/4 "2023-12-05T03:25:25Z")
My initial guess would be the same. Maybe it’s factoring in UTC time somewhere along the lines.
I think I would create two math columns with the following formula.
```auto
Year(Date) * 10^4
+ Month(Date) * 10^2
+ Day(Date)
```
In one column point Date to the start date column. In the other, point Date to Today or Now. Then compare the two in your filter to only include the ones that match.
Dates in Glide seem buggy sometimes. I’ve seen dates be off by several hours in some cases. Can’t really explain it, but I’ve seen weird things at times.
---
### Author:  [@Clifton\_Crouch](https://community.glideapps.com/u/Clifton_Crouch)
#### Post date: [December 5, 2023, 3:41am UTC](https://community.glideapps.com/t/filter-data-by-date-time-is-within-today/68362/5 "2023-12-05T03:41:54Z")
Does this look right?
The Math column doesn’t seem to be recognizing it as a Date. Am I doing something incorrect or do I need an additional step to convert it to a Date?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [December 5, 2023, 3:44am UTC](https://community.glideapps.com/t/filter-data-by-date-time-is-within-today/68362/6 "2023-12-05T03:44:19Z")
That looks correct. The point is to convert it to a number as opposed a date. You’re only using it for your filter.
---
### Author:  [@Clifton\_Crouch](https://community.glideapps.com/u/Clifton_Crouch)
#### Post date: [December 5, 2023, 3:49am UTC](https://community.glideapps.com/t/filter-data-by-date-time-is-within-today/68362/7 "2023-12-05T03:49:55Z")
Okay, I must not be understanding how to set up the filter then.
Would you mind explaining in greater detail how the filter would be set up on the list?
This is my current filter.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [December 5, 2023, 4:09am UTC](https://community.glideapps.com/t/filter-data-by-date-time-is-within-today/68362/8 "2023-12-05T04:09:03Z")
If DateMathToday1 equals DateMathToday2 then that means that row is a Today row.
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [December 12, 2023, 4:09am UTC](https://community.glideapps.com/t/filter-data-by-date-time-is-within-today/68362/9 "2023-12-12T04:09:23Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.