# 🆕 Comparing Dates

**URL:** <https://community.glideapps.com/t/comparing-dates/12214>\
**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:** 1\
**Showing post:** 40

<div class="post-metadata">

**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:** [August 21, 2020, 11:40am UTC](https://community.glideapps.com/t/comparing-dates/12214/40 "2020-08-21T11:40:58Z")

</div>

I have a column that says present or past based on if date for a form submission is “within today” or not.  
These forms are filled by people around the world and the Present/Past value change on basis of a fixed timezone I think. So sometimes for a user on another side of the world the date of the form submission and current date is the same in their timezone but it still shows Past and not Present.

---

_[View the full topic](https://community.glideapps.com/t/comparing-dates/12214)._