Re: Date format to display month name
- From: "Evi" <evwool@xxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 25 May 2008 15:49:13 +0100
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
"reji" <u43819@uwe> wrote in message news:84aef0352e2e1@xxxxxx
I am using Access 2000. In a query I have a field called docdate. I wishto
display this field's month name in same query as January, February, andso
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
.
- References:
- Date format to display month name
- From: reji
- Date format to display month name
- Prev by Date: Date format to display month name
- Next by Date: Re: Date format to display month name
- Previous by thread: Date format to display month name
- Next by thread: Re: Date format to display month name
- Index(es):
Relevant Pages
|