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…

[Screen Shot 2021-03-17 at 9.08.48 PM] The one for min/mins is basically identical.

Do you think it’s possible to use the NOW function in Glide to generate a random number when a form is submitted? I was thinking it would be nice to capture the time when a form is submitted then isolate the seconds … and then re-scale the value to fit between 0 - 1, e.g. multiply by (1/ 0.6) and d…

You can isolate seconds out of Now using something like this in a math column. TRUNC(SECOND(date) /60*100) Or some variation of that depending on how large of a random number you want.

How do I add months and years and not days. I want to calculate when a warranty expires where warranty period is given in months or years. e.g Warranty Expiry = purchase date + 12months or 2 years Using 365 days for the year doesn’t always give you the correct day.

[image] Fun with Dates Project Showcase Here you go. Just use 1.5 years for the number of years, or you can take your number of months and divide by 12. Same thing either way.

Thanks Jeff, but that is what I am currently doing but it’s not 100% accurate. e.g I purchase a car battery on the 9 August 2021(purc_date), it has 18months warranty, so I expect it to expire on 8 Feb 2023. The formula I used was end_date = purch_date + (18/12*365) and the result is 7th Feb 202…

So you are saying that you used one of the following formulas in a math column and the result was not accurate? The following formulas are from the post I shared above. If it’s not working, can you share a screenshot of the formula, the date being feed into it and the result so I can debug my form…

My apologise, I didn’t fully appreciate the logic the first time around, but now I understand what you are doing and it works fine. This is FANTASTIC. Thanks Just one question what the purpose of the “+15”

Essentially what it’s doing taking the entered date, stripping out the DAY number, and subtracting that number from the date, so technically we end up with a date that is the last day of the prior month. Then we add 15 days to get a date that’s in the middle of the entered date’s month and year. So…

🆕 Date-time Math

General

Jeff_Hager August 31, 2021, 3:50pm 108

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

🆕 Date-time Math

Related topics