Finding 1 month back from sysdate

Hello

I am searching for a function or solution which gives date of exact 1 month back from sysdate.

It seems easy but, I afraid that it will create great problem if I do normal coding like just subtracting 1 from month value.

Please help.

Best Regards
Mahesh

Hey

Just I got hint and I could solve the problem

It is add_months(sysdate, -1) in Oracle.

But now I am searching same thing in VB.

How to find exact one month back in VB ?
Using Format, DateDiff or anything else ???

Best Regards
Mahesh

I deleted my previous post.

What date do you want to show if the current date is 10/31/2003? Do you want 09/30/2003?

Well this should do the trick

VB Code:

DateNew = Dateadd(-1,"m",DateOld)

with all respect but I think you've missed it

VB Code:

DateNew = DateAdd("m",-1,DateOld)

S. Mohammad Najafi

Thanks to ALL

vbcodec is right !!!

It is DateNew = DateAdd("m",-1,DateOld)

Mahesh