# Hide after x number of days past date **URL:** \ **Category:** Ask for Help\ **Created:** [July 11, 2020, 8:12pm UTC](https://community.glideapps.com/t/hide-after-x-number-of-days-past-date/12325 "2020-07-11T20:12:02Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [July 11, 2020, 8:12pm UTC](https://community.glideapps.com/t/hide-after-x-number-of-days-past-date/12325/1 "2020-07-11T20:12:03Z")
Need to hide item after x number of days. Date is captured, after say 7 days has past, hide item. Possible? how? Got brain ache (too much gliding!) Cheers 🍻 ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [July 11, 2020, 8:23pm UTC](https://community.glideapps.com/t/hide-after-x-number-of-days-past-date/12325/2 "2020-07-11T20:23:15Z")
Have a new column in your GSheet. Enter the formula `=ARRAYFORMULA(IF(DATEDIF(A2:A,today(),"D")<7,"Valid","Invalid"))` Assuming your date is in Column A Then use this column with visibility feature in GDE ---
**Author:** ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)\ **Post date:** [July 11, 2020, 8:24pm UTC](https://community.glideapps.com/t/hide-after-x-number-of-days-past-date/12325/3 "2020-07-11T20:24:19Z")
create a date column in glide in your sheet create an arrayformula(be smart here to make one that only calculates for non empty rows) that adds 7 days to the real date you want to add 7 days to so now the date will look normal Then create an if then else saying if the new date column we created is today then hide then in your app set visibility settings if the ifthenelse column is not hide Edit:mannans way look easier ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [July 11, 2020, 8:24pm UTC](https://community.glideapps.com/t/hide-after-x-number-of-days-past-date/12325/4 "2020-07-11T20:24:53Z")
Makes total sense, thanks 🙏 will give it a go. ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [July 11, 2020, 8:25pm UTC](https://community.glideapps.com/t/hide-after-x-number-of-days-past-date/12325/5 "2020-07-11T20:25:58Z")
Thanks for your suggestion đź‘Ť ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [July 11, 2020, 8:27pm UTC](https://community.glideapps.com/t/hide-after-x-number-of-days-past-date/12325/6 "2020-07-11T20:27:44Z")
Let me know if it solves your problem. With some more complex calculations, we can do the same in the GDE to eliminate lag but that would involve creating many more columns. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [July 11, 2020, 8:29pm UTC](https://community.glideapps.com/t/hide-after-x-number-of-days-past-date/12325/7 "2020-07-11T20:29:10Z")
Has anyone tried to do it with the new Date Comparison feature in Data Editor? ---
**Author:** ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)\ **Post date:** [July 11, 2020, 8:30pm UTC](https://community.glideapps.com/t/hide-after-x-number-of-days-past-date/12325/8 "2020-07-11T20:30:12Z")
yes ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [July 11, 2020, 8:31pm UTC](https://community.glideapps.com/t/hide-after-x-number-of-days-past-date/12325/9 "2020-07-11T20:31:12Z")
It worked? ---
**Author:** ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)\ **Post date:** [July 11, 2020, 8:32pm UTC](https://community.glideapps.com/t/hide-after-x-number-of-days-past-date/12325/10 "2020-07-11T20:32:26Z")
you can not use it with other dates except if you use is ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [July 11, 2020, 8:37pm UTC](https://community.glideapps.com/t/hide-after-x-number-of-days-past-date/12325/11 "2020-07-11T20:37:39Z")
Did try that but couldn’t seem to get it to work, yet. Maybe need more practice 🙂 ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [July 11, 2020, 8:38pm UTC](https://community.glideapps.com/t/hide-after-x-number-of-days-past-date/12325/12 "2020-07-11T20:38:25Z")
Yes, I gotta try also ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [July 11, 2020, 8:41pm UTC](https://community.glideapps.com/t/hide-after-x-number-of-days-past-date/12325/13 "2020-07-11T20:41:48Z")
Be great it if did work, although suspect will need to calculate on dates which is not possible ---
**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:** [July 12, 2020, 1:02am UTC](https://community.glideapps.com/t/hide-after-x-number-of-days-past-date/12325/14 "2020-07-12T01:02:46Z")
Yep, currently we can’t do calculation with dates so it should be handled in the Sheets, either by using Manan’s formula or creating a new column calculating what is the “Date capture + 7 days” value, then compare that using an If \> Then \> Else in Glide.