Date Functions Making Life Difficult

[ChopinFan]

I'm seriously confused over this. Why does this datepart syntax correctly return "11":

=DatePart("m",DateAdd("m",-1,Date()))

And this format syntax incorrectly return "January"??:

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

Help?

 

[MichaelRed]

RTFM? (e.g. the ubiquitous {F1}[/b[ (aks H E L P[/color0)




MichaelRed

 

[THWatson]

ChopinFan
Is there a reason not to use just
Format(DateAdd("m",-1,Date()),"mmmm")

That will give you November.

Tom

 

[ChopinFan]

Hi Tom,

I had been combining from two other fields and overlooked the obvious.

Thanks!