# Date is not within 'today' **URL:** \ **Category:** Ask for Help\ **Created:** [May 6, 2021, 11:24am UTC](https://community.glideapps.com/t/date-is-not-within-today/26478 "2021-05-06T11:24:01Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![adriasoce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adriasoce/32/24153_2.png) [@adriasoce](https://community.glideapps.com/u/adriasoce)\ **Post date:** [May 6, 2021, 11:24am UTC](https://community.glideapps.com/t/date-is-not-within-today/26478/1 "2021-05-06T11:24:01Z")
Hi! I want to ask you how can i turn this if: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/1/c192ad0c69482c82ad0c61d53737f5164a7f1d5e.png) I mean how can i make: MyDate is NOT within today. ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [May 6, 2021, 12:01pm UTC](https://community.glideapps.com/t/date-is-not-within-today/26478/2 "2021-05-06T12:01:28Z")
Hola @adriasoce Have you tried is before or after today? ---
**Author:** ![adriasoce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adriasoce/32/24153_2.png) [@adriasoce](https://community.glideapps.com/u/adriasoce)\ **Post date:** [May 6, 2021, 12:15pm UTC](https://community.glideapps.com/t/date-is-not-within-today/26478/3 "2021-05-06T12:15:29Z")
Yes, for now I think i can changed it for is before. But I tried in an if condition where i have COND1 AND (date is not within today). Only the second part is equal to “Date is before today or date is after today”. But when we put them with an AND we cannot use an AND and an OR in the same condition. That’s why we need an is NOT within today. I hope you can understand the use case. ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [May 6, 2021, 12:16pm UTC](https://community.glideapps.com/t/date-is-not-within-today/26478/4 "2021-05-06T12:16:54Z")
I’ve accomplished this by using an IF-THEN column to check if the date is within today — result = true. Then in the component itself, just apply a filter that checks for cells that aren’t true. This will give you the rows where the date is not within today. ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [May 6, 2021, 12:20pm UTC](https://community.glideapps.com/t/date-is-not-within-today/26478/5 "2021-05-06T12:20:25Z")
Yep, as @kyleheney said. ITE is your best bet. ---
**Author:** ![adriasoce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adriasoce/32/24153_2.png) [@adriasoce](https://community.glideapps.com/u/adriasoce)\ **Post date:** [May 6, 2021, 12:30pm UTC](https://community.glideapps.com/t/date-is-not-within-today/26478/6 "2021-05-06T12:30:40Z")
@kyleheney @SantiagoPerez yes but i’m creating an action and i cannot put an ifthenelse column in that conditions. That multiple conditions only allow AND or OR but in all conditions, not a mixed. ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [May 6, 2021, 1:00pm UTC](https://community.glideapps.com/t/date-is-not-within-today/26478/7 "2021-05-06T13:00:06Z")
I usually create these using ITE then use them in the action conditions. ---
**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:** [May 6, 2021, 1:03pm UTC](https://community.glideapps.com/t/date-is-not-within-today/26478/8 "2021-05-06T13:03:14Z")
I do that too 😉 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/a/5ac4f27c0e7cb8c637a38bcfc99f2e5d3066bdda.png) and that’s just to determine if actions can even run. ---
**Author:** ![adriasoce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adriasoce/32/24153_2.png) [@adriasoce](https://community.glideapps.com/u/adriasoce)\ **Post date:** [May 6, 2021, 1:10pm UTC](https://community.glideapps.com/t/date-is-not-within-today/26478/9 "2021-05-06T13:10:03Z")
Wow, okey thanks, i will do that