# European Date Format Displays Correctly but Interprets Wrong in Calculations **URL:** \ **Category:** Ask for Help\ **Created:** [April 8, 2025, 12:25pm UTC](https://community.glideapps.com/t/european-date-format-displays-correctly-but-interprets-wrong-in-calculations/81228 "2025-04-08T12:25:04Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![scotfield123](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scotfield123/32/62356_2.png) [@scotfield123](https://community.glideapps.com/u/scotfield123)\ **Post date:** [April 8, 2025, 12:25pm UTC](https://community.glideapps.com/t/european-date-format-displays-correctly-but-interprets-wrong-in-calculations/81228/1 "2025-04-08T12:25:04Z")
Hi all, I’m struggling with a **date formatting issue** in Glide that’s affecting my date calculations. I need to calculate remaining days between Today and the Re-Test Day, both are being read as MM/dd/yyyy instead of dd/MM/yyyy and it gives me wrong results. How is the workaround to show bot dates in the same style and have the remaining days correctly calculated? Kind regards ![DATES](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/e/ee72bc31b9c15c33042ddad1f6b7f336829d6cbf.png) ---
**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:** [April 8, 2025, 2:12pm UTC](https://community.glideapps.com/t/european-date-format-displays-correctly-but-interprets-wrong-in-calculations/81228/2 "2025-04-08T14:12:56Z")
How are you calculating days remaining? The most reliable way is with a math column: Date 2 - Date 1 As long as both columns are date/time types, you will always get the correct result, regardless of any formatting. ---
**Author:** ![scotfield123](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scotfield123/32/62356_2.png) [@scotfield123](https://community.glideapps.com/u/scotfield123)\ **Post date:** [April 8, 2025, 2:29pm UTC](https://community.glideapps.com/t/european-date-format-displays-correctly-but-interprets-wrong-in-calculations/81228/3 "2025-04-08T14:29:06Z")
I have two tables: - **Table 1:** A list of items (accessories). - **Table 2:** Thorough examination inspections linked to the items in Table 1. Every time an inspection is completed, it generates a new **re-test date** in Table 2. I then need to show this re-test date back in Table 1, so I can track when the next inspection is due. To handle this, I created an **If-Then-Else** column in Table 1: - If the item has an inspection → use the **re-test date from the inspection** (Table 2). - If there’s no inspection yet → use the **original re-test date** from Table 1. The issue is that Glide treats the result of this If-Then-Else column as **text** , not an actual date/time value. So when I try to calculate **remaining days** using a math column (e.g. `Re-Test Date - Today`), the calculation is wrong or doesn’t work at all, because it’s reading a string, not a date. That’s why I’m getting incorrect results — even though the formatting _looks_ right, the underlying data type isn’t usable for date math. ---
**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:** [April 8, 2025, 2:48pm UTC](https://community.glideapps.com/t/european-date-format-displays-correctly-but-interprets-wrong-in-calculations/81228/4 "2025-04-08T14:48:45Z")
Try passing your if-then-else column through a math column. ---
**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:** [April 8, 2025, 11:33pm UTC](https://community.glideapps.com/t/european-date-format-displays-correctly-but-interprets-wrong-in-calculations/81228/5 "2025-04-08T23:33:41Z")
So at the moment you’re using the Latest Re-Test Date Format column for calculating, hence the issue? ---
**Author:** ![scotfield123](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scotfield123/32/62356_2.png) [@scotfield123](https://community.glideapps.com/u/scotfield123)\ **Post date:** [April 9, 2025, 8:40am UTC](https://community.glideapps.com/t/european-date-format-displays-correctly-but-interprets-wrong-in-calculations/81228/6 "2025-04-09T08:40:28Z")
i was planing to but because the if-then-else ‘‘Latest Re-test date’’ is showing the date as a text instead of date it messes up everything. I think I found the problem, because most of the things the app do involves generating documents with docs automator everytime I have a date/time column i use another column (Format Date) in order to format the date to be show correctly in the document. in this if-then-else column instead of passing trough the date column i used the date format column wich is seen as text. as soon as I changed it with date column the calculation was right. Thank you all for your inputs. I apreciated ![aaaaaaaaaaaaaa](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/7/b7a02a6dfd8b89c6fcc670978164e57fa1499042.png)