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

[msamps]

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.

[Darren_Murphy]

See below:

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 link to it, but the second formula dealt with adding years, and also accounted for leap year, so if you added 1 year to Feb 29th, then the next year if would calculated to Feb 28th instead of March 1st. Essentially it would figure out if the month of the future calculate…

[msamps]

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

[msamps]

Got it working thank you

[Darren_Murphy]

Excellent

[Robert_Petitto]

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' + (inputDate.getMonth() + 1)).slice(-2); // Adding 1 to the month since it is zero-based
var day = ('0' + inputDate.getDate()).slice(-2);

// Constructing the updated date string
var updatedDate = year + '-' + month + '-' + day;

return updatedDate;