The Math column can now do math with date/times. In particular: Subtracting two date/times produces a duration, which is a number and is measured in days, like in Google Sheets. Adding a duration (number) to a date/time, or subtracting it from a date/time will add/subtract that many days to it. Y…

[image] [image] Is this what you mean ? I’m still playing around with one negative figure. I’ll have it fixed tomorrow.

Exactly that is what I meant, the negative sign although I found how you got rid of it somehow complicated But hopefully one day I will find a way. Thank you for your reply :pray:t2:

Just download my dummies guide. I’ll be adding more math tricks and comparisons.

Where can I find your guide to download it?

Scroll up. It’s called idiots guide.

Why are your check out and check in time shown in math type?

Hey @ThinhDinh , Just found that it is calculating in Days. So need to *24 to convert it to Hours. Thanks for your response!

Yes now I can calculate days before birthday without. Requiring a person to enter their Last birthday. Will be adding to it dummies later on.

[image] darder: I was just trying to warn that maybe some Gliders are trying to convert those text columns presenting EU format to the new international, Glide support for date columns. It won’t work. You must start from an USA format date to make it right. When you convert a text data column pr…

🆕 Date-time Math

General

raghav_khandelwal September 19, 2020, 7:41am 52

Hey, I am unable to use Math for calculating Time difference between 2 columns. Can anyone pls guide if i am missing something or is it a bug?
TIme 2

Topic		Replies	Views
Fun with Dates Project Showcase	156	6940	April 19, 2022
New computed column: Math General	96	6353	November 12, 2021
📅 Guide on Dates & Times Community Resources	22	1675	April 2, 2025
🗓 Month, Day, and Year Math Functions Ask for Help	47	3862	July 15, 2023
If then else with DATE Ask for Help	28	3302	May 25, 2022

🆕 Date-time Math

Related topics