Expand my Community achievements bar.

Calculate 3 months from date

Avatar

Level 3

Hi,

I need to calculate exactly 3 months from a given date.  Given the number of days in months vary, what kind of script do I need to achieve this?

Thanks,

Peta

1 Reply

Avatar

Level 3

I solved my own problem.

I was looking for a complicated solution, but chose to make it 90 days instead of 3 months and this is how I did it using FormCalc.

$ = Num2Date((Date2Num(PTFromDate.formattedValue, "DD/MM/YYYY") + 90), "DD/MM/YYYY")

Works perfectly.  However if the client insists on a 3 month calculation instead of 90 days, then I'm still stuck.

Peta