You can now compare two dates in Glide as opposed to comparing to only ‘Today’ or ‘Now’.
This is AMAZING (the fact that it was requested at the start of the week and it is live!).
Very helpful feature.
All hail the Glide team!
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!
What a great reply, made me laugh. I love date updates as they are so useful…
This hopefully gives me some work to do in my app. Still hoping for filtering on a relation column. Then I’ll be golden.
You can do math operation on dates too btw. That was my first implementation of date comparaison. But WAY EASIER now
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…
Is that just a date or a timestamp? Have you tried converting it to days?
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).
Yes! I have a very specific use case for this, subscriptions!
Can you try making two template columns from those and do math on those columns instead?
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
What does it return at the start, you applied the division already right? Any chance it’s 100000?
Yes, I applied the division directly in the initial calculation. If I withdraw it it gives 5000000 …
What does 5 and 10 mean in this context? I see you have a 2,00 value in one column.
Thank you for adding this. It should help in many ways!
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!!!