Sign in to Community
Sign in to view all badges
Expand my Community achievements bar.
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?
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.