Date minus one month?

  • Thread starter Thread starter Jeni
  • Start date Start date
J

Jeni

Guest
I want to produce a date in a report. It has to be the current month & year MINUS one month. I can format for current month and can do the current date minus one month but cannot get it to show only the month & year.
eg DateAdd("y",-25,[Text30]) where Text30 is =Format Date()("mmmm,yyyy")etc.Can I format the "=Format date " text box to simply take off one month?
 

Users who are viewing this thread

Back
Top Bottom