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?
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?