• 14 years ago


    In a query I have this as a field:

    FormDate:Format(Table_Event.Event_Date;"dddd\ d\ mmmm\ yyyy")

    in order to Obtain: Monday 22 july 2006

    but I Obtained monday 22 july 2006


    How to change the m to M...?


    Using Access 2002 in 2003 is already capital





  • 14 years ago

    Hi enzom

    Since I don't have access 2002 in my PC

    Try it like this:

    FormDate:Format(Table_Event.Event_Date;"dddd\ D\ mmmm\ yyyy")



  • 14 years ago

    Thanks but the same result...!

    d or D has the same result...!  :-(

  • 14 years ago

    This is I beleive caused by American v English date formats.


    The only sure way I have foungd to get round it is to create date fields in medium date format.  These fields must be assigned this format when created as must text boxes on any forms used.

Post a reply

Enter your message below

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“I have always wished for my computer to be as easy to use as my telephone; my wish has come true because I can no longer figure out how to use my telephone” - Bjarne Stroustrup