Back to discussion

Format

Last post was 08 Oct 2006 at 21:57
access Montreal, Canada
  • 14 years ago

    Hi,

    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

     

    Thanks

     

    Enzo

    Report abuse
  • 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")

    Regards

    DoctorMahdi

    Report abuse
  • 14 years ago

    Thanks but the same result...!

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

    Report abuse
  • 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.

    Report abuse

Post a reply

Enter your message below

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

MS Access forum discussion

Quick links

Recent activity

Contribute

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!

Web Development

Developer Jobs

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.

Cancel
“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