Previous Month

[vvasudev]

hello,

I need to update a current field with the Previous Month.ie a query to update column with the name of the previous month Like Jan or January etc..Any help would be highly appreciated

 

[HiTechCoach]

Not sure exactly what you are trying to do.

Maybe this will help:

Date() = 12/15/2009

? MonthName(Month(Date())-1)
November

 

[vvasudev]

Thanks a million times mate..U have saved enormous time and really greatful for the quick response...


cheers
Vineeth

 

[HiTechCoach]

You're welcome.

Glad we could assist.

Cheers