# 🆕 Comparing Dates **URL:** \ **Category:** General\ **Created:** [July 9, 2020, 12:56pm UTC](https://community.glideapps.com/t/comparing-dates/12214 "2020-07-09T12:56:20Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\ **Post date:** [July 9, 2020, 12:56pm UTC](https://community.glideapps.com/t/comparing-dates/12214/1 "2020-07-09T12:56:20Z")
You can now compare two dates in Glide as opposed to comparing to only ‘Today’ or ‘Now’. ![Screen Shot 2020-07-09 at 8.03 1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/2246182c6e653bfbb7dadda3d26385f37e0b648d.jpeg) ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [July 9, 2020, 12:57pm UTC](https://community.glideapps.com/t/comparing-dates/12214/2 "2020-07-09T12:57:17Z")
This is AMAZING (the fact that it was requested at the start of the week and it is live!). ---
**Author:** ![S\_C](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/s_c/32/12766_2.png) [@S\_C](https://community.glideapps.com/u/S_C)\ **Post date:** [July 9, 2020, 1:01pm UTC](https://community.glideapps.com/t/comparing-dates/12214/3 "2020-07-09T13:01:12Z")
Very helpful feature. ---
**Author:** ![Lisa](https://avatars.discourse-cdn.com/v4/letter/l/f08c70/32.png) [@Lisa](https://community.glideapps.com/u/Lisa)\ **Post date:** [July 9, 2020, 1:08pm UTC](https://community.glideapps.com/t/comparing-dates/12214/4 "2020-07-09T13:08:44Z")
All hail the Glide team! 🤟 ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [July 9, 2020, 1:15pm UTC](https://community.glideapps.com/t/comparing-dates/12214/5 "2020-07-09T13:15:16Z")
Please withdraw this function: I’ve spent the night to build something with “1000” relations & lookup & etc columns (that I already do not understand any more) to do exactly what you do… in 1 clic! 🙂 Great! ---
**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 9, 2020, 1:28pm UTC](https://community.glideapps.com/t/comparing-dates/12214/6 "2020-07-09T13:28:02Z")
What a great reply, made me laugh. I love date updates as they are so useful… ---
**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:** [July 9, 2020, 2:56pm UTC](https://community.glideapps.com/t/comparing-dates/12214/7 "2020-07-09T14:56:21Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/5638ee44917263d97c799caa6b82f7a909dc87ae.png) This hopefully gives me some work to do in my app. Still hoping for filtering on a relation column. Then I’ll be golden. ---
**Author:** ![Thibault\_Milan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thibault_milan/32/4970_2.png) [@Thibault\_Milan](https://community.glideapps.com/u/Thibault_Milan)\ **Post date:** [July 9, 2020, 3:09pm UTC](https://community.glideapps.com/t/comparing-dates/12214/8 "2020-07-09T15:09:48Z")
You can do math operation on dates too btw. That was my first implementation of date comparaison. But WAY EASIER now 👍 ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [July 9, 2020, 3:40pm UTC](https://community.glideapps.com/t/comparing-dates/12214/9 "2020-07-09T15:40:47Z")
How did you do calculations on “dates”? I tried the formula (T - DS) / F … I’m not a rock star in maths, but I have my doubt on the result… ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/fecbd5cc58593d022c326b43db9ef0297ecd5671.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:** [July 9, 2020, 3:47pm UTC](https://community.glideapps.com/t/comparing-dates/12214/10 "2020-07-09T15:47:27Z")
Is that just a date or a timestamp? Have you tried converting it to days? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1c84618be6991526ae3a8f23d628ba5d358b4290.png) ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [July 9, 2020, 4:00pm UTC](https://community.glideapps.com/t/comparing-dates/12214/11 "2020-07-09T16:00:10Z")
Interesting indeed! In my example, both T & DS fields are date I think. How come that there is a .52 while 12 - 2 = 10.00? Is it due to the fact that even if not displayed, it takes into account the hours? (if ‘yes’, arrgh, doesn’t comply with my need). ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f5dfb4fbcbd5a6fd845a8929b94a3facb4bd9d09.png) ---
**Author:** ![Carlos\_DeSilva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos_desilva/32/19965_2.png) [@Carlos\_DeSilva](https://community.glideapps.com/u/Carlos_DeSilva)\ **Post date:** [July 9, 2020, 4:01pm UTC](https://community.glideapps.com/t/comparing-dates/12214/12 "2020-07-09T16:01:47Z")
Yes! I have a very specific use case for this, subscriptions! ---
**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 9, 2020, 4:02pm UTC](https://community.glideapps.com/t/comparing-dates/12214/13 "2020-07-09T16:02:00Z")
Can you try making two template columns from those and do math on those columns instead? ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [July 9, 2020, 4:12pm UTC](https://community.glideapps.com/t/comparing-dates/12214/14 "2020-07-09T16:12:23Z")
It doesn’t like it very much… I think I’ll stay with my current solution at this stage (even if very it intricates multiple relation, lookups & co), notably because I found Glide very weak with regards to ‘Date’ management in EU format. But thanks (again!) for trying to help. (t\_) = template columns ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/ebd0288a31a1034582e217fc47f3cee1e0954064.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:** [July 9, 2020, 4:13pm UTC](https://community.glideapps.com/t/comparing-dates/12214/15 "2020-07-09T16:13:28Z")
What does it return at the start, you applied the division already right? Any chance it’s 100000? ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [July 9, 2020, 4:58pm UTC](https://community.glideapps.com/t/comparing-dates/12214/16 "2020-07-09T16:58:59Z")
Yes, I applied the division directly in the initial calculation. If I withdraw it it gives 5000000 … ---
**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 9, 2020, 5:10pm UTC](https://community.glideapps.com/t/comparing-dates/12214/17 "2020-07-09T17:10:31Z")
What does 5 and 10 mean in this context? I see you have a 2,00 value in one column. ---
**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:** [July 9, 2020, 5:46pm UTC](https://community.glideapps.com/t/comparing-dates/12214/18 "2020-07-09T17:46:24Z")
Thank you for adding this. It should help in many ways! ---
**Author:** ![Mr\_Watkin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mr_watkin/32/349_2.png) [@Mr\_Watkin](https://community.glideapps.com/u/Mr_Watkin)\ **Post date:** [July 9, 2020, 5:55pm UTC](https://community.glideapps.com/t/comparing-dates/12214/19 "2020-07-09T17:55:49Z")
So awesome to see that there is an easy way to do this now! On my app users collect eggs that age and hatch accordingly. This will rock to have the app choose a photo to display based on the number of days since collection!!! 🥚 🦖 ---
**Author:** ![Thibault\_Milan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thibault_milan/32/4970_2.png) [@Thibault\_Milan](https://community.glideapps.com/u/Thibault_Milan)\ **Post date:** [July 9, 2020, 7:39pm UTC](https://community.glideapps.com/t/comparing-dates/12214/20 "2020-07-09T19:39:47Z")
Weird, for just two date operation it’s still in days ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1d9e7b1640c1f4923a21123a9c33831a5c31dec7.png) But as soon as I apply number like a `/2` it converted in timestamp [Next page](https://community.glideapps.com/t/comparing-dates/12214.md?page=2)