# Date withing a date range → TRUE **URL:** \ **Category:** Ask for Help\ **Created:** [February 9, 2023, 8:26pm UTC](https://community.glideapps.com/t/date-withing-a-date-range-true/57725 "2023-02-09T20:26:27Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![curlynoemi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/curlynoemi/32/50544_2.png) [@curlynoemi](https://community.glideapps.com/u/curlynoemi)\ **Post date:** [February 9, 2023, 8:26pm UTC](https://community.glideapps.com/t/date-withing-a-date-range-true/57725/1 "2023-02-09T20:26:27Z")
I am creating an event tracker and I need a column to be checked if the event is happening right now. Given the start and end date in two different columns. For example: TODAY IS: February 9, 2023 EVENT START: February 9, 2023 EVENT END: February 11, 2023 I want a check because today is withing the event date range. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 9, 2023, 8:46pm UTC](https://community.glideapps.com/t/date-withing-a-date-range-true/57725/3 "2023-02-09T20:46:38Z")
Do you have an IF column set up already that isn’t working quite right? Do your events have times, or are you just looking at dates without time? ---
**Author:** ![curlynoemi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/curlynoemi/32/50544_2.png) [@curlynoemi](https://community.glideapps.com/u/curlynoemi)\ **Post date:** [February 9, 2023, 8:50pm UTC](https://community.glideapps.com/t/date-withing-a-date-range-true/57725/4 "2023-02-09T20:50:50Z")
Events are date only and I’ve tried with “now” function real quick but i gave up bacause i don’t really know what to do. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/1/3155ba4c660b4d44aada2d652c9267316ad9e7cf.png) ---
**Author:** ![curlynoemi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/curlynoemi/32/50544_2.png) [@curlynoemi](https://community.glideapps.com/u/curlynoemi)\ **Post date:** [February 9, 2023, 9:03pm UTC](https://community.glideapps.com/t/date-withing-a-date-range-true/57725/5 "2023-02-09T21:03:19Z")
can you give me a screenshot example? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 9, 2023, 9:18pm UTC](https://community.glideapps.com/t/date-withing-a-date-range-true/57725/6 "2023-02-09T21:18:20Z")
Date’s are a little tricky because even though you have them formatted to show only the date, they can still contain an underlying time. Sometimes that can bite you. Also, some comparisons in the IF column will compare only the dates, while others will factor in the time. ‘Within’ for example, will only compare the date as a whole. It does not look at time. Whereas Before or After may look at time. It’s a bit confusing and usually takes some trial and error to figure out. I think this IF column should be pretty safe, but I would make sure to test it thoroughly. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/2/b2622453599085c5a935a3cbea7214be957581e8.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 10, 2023, 12:50am UTC](https://community.glideapps.com/t/date-withing-a-date-range-true/57725/7 "2023-02-10T00:50:28Z")
Also, is there a reason you store all these info in user-specific columns?