Display last month and year

R

ryangus

In additiion to my previous post, I need to display the previous month
and year to the current month. e.g. for March 2007, I want to show
February 2007, for January 2007, show December 2006 etc.

Can anyone please point out how to do this?
 
R

ryangus

In additiion to my previous post, I need to display the previous month
and year to the current month. e.g. for March 2007, I want to show
February 2007, for January 2007, show December 2006 etc.

Can anyone please point out how to do this?
Click to expand...

Never mind - worked it out using the repsonse to my previous post
(thanks again Allen Browne):

=(Date()-Day(Date()))

format mmmm yyyy
 
A

Allen Browne

Set these properties for your text box:
Control Source: =Date() - Day(Date())
Format: mmmm yyyy

If it has to be part of other text, use this kind of thing:
="For the month of " & Format(Date() - Day(Date()), "mmmm yyyy")
 
Top