Adding months to Date in Server Edition

[sridharvg]

Hi,

Can you please tell us how to add months to Date format in Server Edition using OCONV(ICONV....

Thanks in Advance,
Sridhar.

[chulett]

Depends on your definition of 'month'. Typically, you either add a number of days to the date or break it up into component pieces and bump the month (and perhaps year and day) individually. Both Ray and Ken have routines to do this available for download, from what I recall.

[test]

[quote="sridharvg"]Hi,

Can you please tell us how to add months to Date format in Server Edition using OCONV(ICONV....

Thanks in Advance,
Sridhar.[/quote]


Hi
you can try this..
First Convert the date to month format..
like Oconv(date(),"D-M") result is 1 or 2 or ...12 based on the system date
For Eg:today's date 26-11-2008---->11

then add the number i.e., which month u want the date to be..


Like if u need DEC then add 1


Finally the expression will be

OConv(IConv(Oconv(date(),"D-M")+1),"D-M"),"D-YMD[4,2,2]")

I guess..this gives you the 1st dec date

[test]

[quote="sridharvg"]Hi,

Can you please tell us how to add months to Date format in Server Edition using OCONV(ICONV....

Thanks in Advance,
Sridhar.[/quote]


Hi
you can try this..
First Convert the date to month format..
like Oconv(date(),"D-M") result is 1 or 2 or ...12 based on the system date
For Eg:today's date 26-11-2008---->11

then add the number i.e., which month u want the date to be..


Like if u need DEC then add 1


Finally the expression will be

OConv(IConv(Oconv(date(),"D-M")+1),"D-M"),"D-YMD[4,2,2]")

I guess..this gives you the 1st dec date

[test]

[quote="sridharvg"]Hi,

Can you please tell us how to add months to Date format in Server Edition using OCONV(ICONV....

Thanks in Advance,
Sridhar.[/quote]


Hi
you can try this..
First Convert the date to month format..
like Oconv(date(),"D-M") result is 1 or 2 or ...12 based on the system date
For Eg:today's date 26-11-2008---->11

then add the number i.e., which month u want the date to be..


Like if u need DEC then add 1


Finally the expression will be

OConv(IConv(Oconv(date(),"D-M")+1),"D-M"),"D-YMD[4,2,2]")

I guess..this gives you the 1st dec date

[chulett]

You guess? Ironic question, but did you test this?

[ray.wurlod]

Try the AddMonths routine from here