Show month

[mu]

Hello everyone

How can I get a 1 text box to display the current month and another text box to display the previous month ?
Obviously at the begining of each month I would need them to update automatically.

It looks really obvious and probably it is but I cant find a way to do it.

Thanks

mu

 

[Elana]

To display the current month, create a text box and place this in the control source:

=Format(Date(),"mmmm")

To display the previous month, create another textbox and place this in the control source:

=Format(Date()-31,"mmmm")

 

[mu]

Thanks elana

How quicks that, I'd only just got back to the forum page and its there.

mu