Hi,
I have seen addDays, addWeeks, addyear in functions, How can I add months to a specific date.
Regards,
-Naveen
Userlevel 5
+16
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.
+4
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
Reply
View our Community Site Map
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.