Interesting. @L.M That is what I get as well. What do you get when you try the other code below. Use either of the date columns for p1
return (typeof p1) + " - " + p1
No. p1 should just be one of your date columns. Also you are missing the “R” in return.
That’s indeed what I tried first, but
BTW, it’s “Return” not “eturn”, no mispelling in the code used, just the screen cap a little late
Make it all lower case: return
Thks, George. Happy to help.
Do you happen to know if Glide stores user’s Time Zone whenever a “current user’s time” is set?
To retrieve if later on.
I don’t believe that glide stores the user’s timezone. That needs to be calculated on your end. Obviously several of those options below are plugins, so may or may not work correctly for you, but it gives you a few options to try.
@L.M If you use Google Sheets you could create two columns and use these formulas on row one of each column. Obviously, change the column references to the two date columns. Then use those two columns in your DateDiff p1 and p1 parameters.