Howto return Previous month name

[Jay]

How can I return the previous month name using the following:

Format((date), " mmmm ")

This returns the current month name "March".
I need the previous month name "Feburary"

 

[Allen Browne]

Try:
Format(DateAdd("m", -1, Date()), "mmmm")
or perhaps:
Format(Date() - Day(Date())), "mmmm')

 

['69 Camaro]

Hi, Jay.

How can I return the previous month name

Use the DateAdd( ) function. Try:

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

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Jay]

Try:
Format(DateAdd("m", -1, Date()), "mmmm")
or perhaps:
Format(Date() - Day(Date())), "mmmm')

The first one worked
Format(DateAdd("m", -1, Date()), "mmmm")