assigning a text box value

Carlee · Mar 30, 2005

Hi there,

I have an unbound text box on a report. I want it to display the previous
month's name. How can I do this?

Kind regards,

Rick B · Mar 30, 2005

I think it would be...

=Format(DateAdd("m", -1, Date), "mmmm")

Rick B

Rick B · Mar 30, 2005

make that...

=Format(DateAdd("m",-1,Date()),"mmmm")