Hi,
I have seen addDays, addWeeks, addyear in functions, How can I add months to a specific date.
Regards,
-Naveen
Hi,
I have seen addDays, addWeeks, addyear in functions, How can I add months to a specific date.
Regards,
-Naveen
Hi Naveen,
Good question, am not sure why.
there are workarounds, but what do you mean by month? 28, 30 or 31 days?
you can use the days function with a trick, would this help?
why don't you just add days(30,60) ? it's the same
Hi naveen
I had this requirement too, and used a SQL stored procedure to do it using the DATEADD function. You can create a SmartObject from this stored procedure and use it as a generic method to add months.
It would be a good feature request.
Hi Naveen,
The closest I was able to come without using a sproc is the query below, and it is shoddy at best. Perhaps you can take this and push it over the finishline, I only had +- 10 minutes to write this one up for you.
Now this will push the date forward exactly one month, problems come when it is the 31st of a month, then it will get pushed to the 1st of the 2nd month from that date.
Regards and apologies for the shoddy work there :P
Pieter
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.