Date format to display month name

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

.

Relevant Pages

  • Re: table formatting not carrying to calculated field in query
    ... Format in table design only controls display. ... But why does the query see the formatting in the field "State" ... And because the concantated field ...
    (microsoft.public.access.queries)
  • Re: Very Weird Date Format Problem
    ... Many, many, many thanks John. ... the date fields set format to d All but L1 display the day. ... The query uses a stored field which is the first of the month. ...
    (microsoft.public.access.reports)
  • Re: How to convert text to number in a query?
    ... CCurconverts the value into Currency type data. ... Queries are reallly just the engine, and not really a display interface. ... on your form/report has a Format property. ... The fields in a query do have a Format property too. ...
    (microsoft.public.access.queries)
  • Re: table formatting not carrying to calculated field in query
    ... Format in table design only controls display. ... But why does the query see the formatting in the field "State" ... And because the concantated field ...
    (microsoft.public.access.queries)
  • Re: Trying to import 12 digit number into Access
    ... Create a query that deletes all records from that table. ... I won't actually be doing math on it, however, I will be searching ranges ... daily without having to go to design view each day and change the format ... you can display a date/time value ...
    (microsoft.public.access.externaldata)