Im trying to calculate a warranty expiry date for 6 months after the sold date. Unfortunately glide only seems to be able to add in days and im trying to calculate exactly 6 months after the date sold. Any ideas or help would be appreciated.

See below: [image] If then else with DATE @Darren_Murphy @Milan_Balogh Geez, I had to put on my thinking cap before my morning coffee. The same place that Darren got that original formula had a second formula. It looks like that old thread is unlisted now, so I won’t l…

I tried using his formula and some of the values are incorrect. Maybe i’m implementing it wrong. Watching Darrens video now

Here’s a no-code and a low-code way of doing this: var dateInput = p1; var inputDate = new Date(dateInput); // Adding 6 months to the input date inputDate.setMonth(inputDate.getMonth() + p2); // Get the updated date components var year = inputDate.getFullYear(); var month = ('0' + (inp…

How can I add 6 months to a date in a glide table?

Ask for Help

Darren_Murphy June 22, 2023, 2:10pm 2

See below:

Topic		Replies	Views
Help colum math Ask for Help	10	520	May 7, 2022
Add 60 multiple rows with dates (today + monthly additions) Ask for Help	7	92	August 2, 2024
Create dynamic date Ask for Help	1	352	June 1, 2023
How to calculate next month/year from a specified date Ask for Help	1	891	September 5, 2021
Date math - 3 months from a specific date Ask for Help	9	960	July 20, 2022

How can I add 6 months to a date in a glide table?

Related topics