Print Previous Month on a Report

  • Thread starter theiguanainthesauna
  • Start date
T

theiguanainthesauna

I need to print the previous month and current year on the page footer of my
report. I can get the current date to print using "=Date()" but what I need
is for the report I am printing today to show "January 2006" Is this doable
and if so how? Thanks in advance for your assistance.

TheIguana
 
J

John Spencer

One method that may work for you
=Format(DateAdd("m",-1,Date()),"mmmm yyyy")
 
T

theiguanainthesauna

Nevermind, I figured it out on my own. Well, after reading a few posts I did!
Always love it when I can solve my own issues!
 
Top