European Date Format Displays Correctly but Interprets Wrong in Calculations

Ask for Help
1

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
DATES916×864 72.7 KB

2

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.

3

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.

4

Try passing your if-then-else column through a math column.

2 Likes
5

So at the moment you’re using the Latest Re-Test Date Format column for calculating, hence the issue?

6

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
aaaaaaaaaaaaaa677×674 51.7 KB

1 Like