Get the Current month and year

[#1]

Hello Friends

As I need to store the current month and Year in a variable, what is the function available to get it.

Regards

Chriss.....

[#2]

Hi,

vCurrentYear= year(today())

vCurrentMonth= month(today())

Regards

Apurva

[#3]

Hello Apurva,

Thanks for your reply, my requirement is I need to store the Month and Year in a single variable

like vCurrentMonYear = June 2012. is it possible ....

Regards

Chriss

[#4]

Hi,

use this->  vCurrentYM= monthname(today())

regards

Apurva

[#5]

Thanks Apurva............

[#6]

Hello Apurva,

I need one more favour Using Monthname(today()) I can get the Current Month and Year but when i try Monthname(today()-1) to get the previous month its not working..

Please help me...

Regards

Chriss

[jagannalla]

Hello,

Try this =Date(MonthName(Today())-1,'MMM YYYY')

[jonathandienst]

Chris

No that will get the month name for yesterday. For the previous month use

MonthName(AddMonths(Today(), -1))

Regards

Jonathan

[#9 · Accepted solution]

Hi,

use this

=MonthName(addmonths(today(),-1))

Regrds

Apurva

[#10]

Yes, its works.... thanks a lot Apurva...