A03- Date format in tables?

Discussion in 'Access General' started by StargateFan, Jun 16, 2013.

  1. StargateFan

    StargateFan Guest

    I was wondering if anyone could help. I googled and found how to show
    dates, supposedly, but I haven't gotten anything to work.

    I chose long date in the format but I'm not having luck with finding
    syntax for the short form for the weekday as nothing comes up in the
    many examples there are of date input masks. The long date has the
    full day but I need the short form, i.e, Wed instead of Wednesday.

    Ultimately, the date should read like this:

    Sun Jun 16, 2013

    Any help appreciated. I've been googling for a few hours now for
    different things and my eyes can't handle any more pages today <g>.

    Thanks and cheers.
    StargateFan, Jun 16, 2013
    1. Advertisements

  2. StargateFan

    StargateFan Guest

    Oh, I should have waited. I had 2 tabs left to look at in my FF and
    found what seems to be the answer (I never knew this, but it does seem
    to work!!):

    2013-06-16 15:42:00

    6th Aug 2003
    What you really want is a format, not an input mask. I never put an
    mask on a date/time field as it gets in the way more than it helps.

    Savvy users know that they can enter today's date with 8/6 or 6/8
    on their Regional Settings) - or even using Ctrl-; An input mask would
    require more keystrokes.

    You are not restricted to the formats presented in the pick list; you
    set a custom format such as
    mmmm d, yyyy

    Joan Wild
    Microsoft Access MVP

    Sure enough! Instead of choosing a format in the first box in the
    table's design view (i.e., "General Date", "Long Date", etc.) we just
    need to type in the format we want. In this case, mine is this:


    (just like I use in Excel half the time!)

    Then I saved the table and sure, enough, all the entries now show in
    this format:


    And when you exit the field format, the date format is displayed as


    Neat. Now I have a way to get what I need each and every time, I
    think with regards to date format.

    StargateFan, Jun 16, 2013
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.