Page 1 of 1

last date of next month

Posted: Mon Jun 23, 2008 11:59 am
by Apotluri
I have a date from the inout source and I have to calculate the last date of the next month, Is there a function or a way to get this done?

Thanks, as always

Re: last date of next month

Posted: Mon Jun 23, 2008 11:08 pm
by hello105
I think you can use a store procedure stage to resolve this

Apotluri wrote:I have a date from the inout source and I have to calculate the last date of the next month, Is there a function or a way to get this done?

Thanks, as always

Posted: Tue Jun 24, 2008 12:30 am
by ArndW
No need to code anything external. The high-level logic to do this is to take the date, add 2 months, then subtract one day. The DateFromDaysSince() function performs addition/subtraction from a date.