# Relative date discrepancy **URL:** \ **Category:** Report a Bug\ **Created:** [December 17, 2021, 7:18pm UTC](https://community.glideapps.com/t/relative-date-discrepancy/36063 "2021-12-17T19:18:34Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Rollo\_Wenlock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rollo_wenlock/32/26956_2.png) [@Rollo\_Wenlock](https://community.glideapps.com/u/Rollo_Wenlock)\ **Post date:** [December 17, 2021, 7:18pm UTC](https://community.glideapps.com/t/relative-date-discrepancy/36063/1 "2021-12-17T19:18:34Z")
**My App/Pages Support link:** [https://go.glideapps.com/support/95861589-4648-4312-81f8-9fa0cd1f1132](https://go.glideapps.com/support/95861589-4648-4312-81f8-9fa0cd1f1132) **Describe the bug:** The relative date shows correctly in the app builder preview, but on iPhone in chrome browser and safari browser it shows incorrectly **Expected Behaviour:** The relative date (how many days ago) should be the same both in the app builder preview and on a mobile device **How to replicate:** Open swapsy.co.nz on your mobile device and login as Rollo Wenlock (email me for login credentials [rollowenlock@gmail.com](mailto:rollowenlock@gmail.com)) **Demonstration:** See attached image ![example relative date error](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/5/95f394904f8d2899839372d53fb23004c52a964e.jpeg) ---
**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:** [December 18, 2021, 12:06am UTC](https://community.glideapps.com/t/relative-date-discrepancy/36063/2 "2021-12-18T00:06:16Z")
It might be a problem in handling the date format for the column. I would advise using a centralized UTC date column and writing it to your data on the creation of new rows instead of the native “current date/time”. Also, use that value in the relative date column for the “now” value. I have used it in various apps and it hasn’t failed. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [December 18, 2021, 12:16am UTC](https://community.glideapps.com/t/relative-date-discrepancy/36063/3 "2021-12-18T00:16:55Z")
Have you tried this on other phones? Does it always happen? ---
**Author:** ![Rollo\_Wenlock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rollo_wenlock/32/26956_2.png) [@Rollo\_Wenlock](https://community.glideapps.com/u/Rollo_Wenlock)\ **Post date:** [December 18, 2021, 8:58pm UTC](https://community.glideapps.com/t/relative-date-discrepancy/36063/4 "2021-12-18T20:58:08Z")
It always happens on iphone, i’m afraid I can’t test it on other phones at the moment ---
**Author:** ![Rollo\_Wenlock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rollo_wenlock/32/26956_2.png) [@Rollo\_Wenlock](https://community.glideapps.com/u/Rollo_Wenlock)\ **Post date:** [December 18, 2021, 8:59pm UTC](https://community.glideapps.com/t/relative-date-discrepancy/36063/5 "2021-12-18T20:59:02Z")
Although I appreciate a work around, wouldn’t it be preferable that it works as intended? ---
**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:** [December 18, 2021, 11:57pm UTC](https://community.glideapps.com/t/relative-date-discrepancy/36063/6 "2021-12-18T23:57:44Z")
Yes, I do not disagree with that. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [December 19, 2021, 12:45am UTC](https://community.glideapps.com/t/relative-date-discrepancy/36063/7 "2021-12-19T00:45:31Z")
May we see a screenshot of your relative date column configuration and some examples of the data flowing into it? It sounds like there’s a mixup between Imperial and Metric month-day ordering somewhere. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 19, 2021, 1:24am UTC](https://community.glideapps.com/t/relative-date-discrepancy/36063/8 "2021-12-19T01:24:08Z")
@david this happens with most of the Date related plugins. I’ve stopped using them. They either give inconsistent results or no result at all. As far as I’m aware, they work fine as long as you’re using US locale/date format, but as soon as you aren’t then all bets are off. I first [reported](https://github.com/glideapps/glide-code-columns/issues/86) this back in early November. ---
**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:** [December 19, 2021, 1:30am UTC](https://community.glideapps.com/t/relative-date-discrepancy/36063/9 "2021-12-19T01:30:57Z")
I can confirm similar results — Canada-based. Relative Date columns are blank. If my device/browser is US English, works fine. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 19, 2021, 1:51am UTC](https://community.glideapps.com/t/relative-date-discrepancy/36063/10 "2021-12-19T01:51:14Z")
Yes, it either fails or gives an incorrect result, depending on whether the date is ambiguous. For example, 7th December is an ambiguous date. It could be 7/12 or 12/7, depending on where you are. And both could be interpreted as 7th December or 12th July. For these dates, it will “work”, but give an incorrect result if you are using non-US date format. 19th December on the other hand is non-ambiguous. Even though it can be represented as 19/12 or 12/19, it can _only_ be interpreted one way. The date plugins fail for these dates because they appear to assume mm/dd format, and as there is no 19th month… ---
**Author:** ![Rollo\_Wenlock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rollo_wenlock/32/26956_2.png) [@Rollo\_Wenlock](https://community.glideapps.com/u/Rollo_Wenlock)\ **Post date:** [December 20, 2021, 12:18am UTC](https://community.glideapps.com/t/relative-date-discrepancy/36063/11 "2021-12-20T00:18:48Z")
I’m in New Zealand (day/month/year) so when it comes from the 1730s in the US (month/day/year) it’s getting in a tangle. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [January 19, 2022, 10:28pm UTC](https://community.glideapps.com/t/relative-date-discrepancy/36063/12 "2022-01-19T22:28:46Z")
Closing due to inactivity. This topic will be deleted in a few weeks if there are no more comments. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [January 19, 2022, 10:28pm UTC](https://community.glideapps.com/t/relative-date-discrepancy/36063/13 "2022-01-19T22:28:46Z")
---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [February 19, 2022, 10:27pm UTC](https://community.glideapps.com/t/relative-date-discrepancy/36063/14 "2022-02-19T22:27:56Z")
---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [February 19, 2022, 10:27pm UTC](https://community.glideapps.com/t/relative-date-discrepancy/36063/15 "2022-02-19T22:27:56Z")