Format

  • 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

  • 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

  • 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).

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!

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.

“Brevity is the soul of wit” - Shakespeare