I made a video to best describe the behaviour the Relative Time column is giving me, but it’s essentially displaying the data differently in the components compared to what it’s showing in the data table.
What are the values for your Start Time column and your End Time Lookup column? Does your Lookup column refer to a table that has row owners applied? If row owners isn’t the issue, then I would try formatting your start and end dates to also include the date just to see if that makes a difference.
You can just about see the End Time column at 15secs, the Start Time is also the same format e.g. 01/02/2022, 12:00:00
I don’t want to change those formats as they are sent in webhook data that is part of many very large Integromat scenarios with lots of formatting/parsing.
It appears to work fine though as the video demonstrates, it’s what is showing in the component when the start time is edited from the Date Time component.
What’s even WEIRDER is that when I edit the start time manually in the data table, the error is reversed! So that in the data table it shows ‘1 month’ and then the correct calculation is in the component!
Note the error value is always 1 month, or 30d (when I change the Relative Time to ‘mini’.
Wohoa this is big time buggy! Well spotted, yes so that 2nd observation of when I manually edit the time in the data table it switched around the day and month. Not really a use case as it will only be altered via a Date Time component, so not too worried about that issue.
My normal format is DD/MM/YYYY
More pertinent in the first instance the computation is correct in the data table based on the Start and End Times, and it shows the CORRECT result in the table, just the INCORRECT one in the component.
That isn’t congruent with my experience. When the Date Picker component changes the time, it writes it in the correct DD/MM/YYYY format that I need - and that’s reinforced by the fact that in the data table the Relative Time column calculates the correct value…
It’s only when I choose to show that data does the alternate computation (shown nowhere else) display itself.
Maybe mine looks like your Meet with Me APP because when I wanted to create my own booking app and find out the problems and challenges to get it after reading many threads about it I remembered your first version and by accident, I started my work following your layout but later (of course), I changed it while I was developing the logic and options.
Sorry if this causes you a discomfort.
As a proof, I show you my backend for it. I developed this demo APP using the new plugins and XC (JS code) in order to make simple my logic and avoid creating and manipulating so many computed columns (math, ITE, Template)