Date format to display month name

R

reji

I am using Access 2000. In a query I have a field called docdate. I wish to
display this field's month name in same query as January, February, and so
on . So I typed the command Month:Format([docdate],'mmmm').
But when I try tun the query, getting error mesage - undefined function "
Format " in expression.

Please help me.


Regards,


Reji
 
E

Evi

Very close, just put full quotes around the mmmm bit and don't call it Month
(a Reserved word) except in your labels and captions

Mnth:Format([docdate],"mmmm")

Evi
 
C

Chris O'C via AccessMonster.com

If your db has any missing references, any VBA function used will result in
"undefined function" but it really means there are other functions not
defined because of the missing libraries. Fix the missing references and
your VBA code will work.

Chris
Microsoft MVP

I am using Access 2000. In a query I have a field called docdate. I wish to
display this field's month name in same query as January, February, and so
on . So I typed the command Month:Format([docdate],'mmmm').
But when I try tun the query, getting error mesage - undefined function "
Format " in expression.

Please help me.

Regards,

Reji
Click to expand...
 
Top