1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Date format not working

Discussion in 'Business Applications' started by DKTaber, Nov 29, 2010.

Thread Status:
Not open for further replies.
Advertisement
  1. DKTaber

    DKTaber Thread Starter

    Joined:
    Oct 26, 2001
    Messages:
    2,871
    I just installed a split database on a non-profit organization's computer. In a table that contains date fields, I had set the date format to "m/d/yy" when defining the table fields on my computer. When I subsequently designed the input forms for the table, the dates show correctly in that format.

    But when I installed the database on the client's computer, the dates show in "m/d/yyyy" format. I thought it might be because that computer's Regional Date Options were set to that format. However, I just experimented on my computer, changing the Regional Date format to "m/d/yyyy", then opening the database to see if the Regional format overrode the format defined in the table. It does not.

    So. . . any idea why despite the date format being defined in the table as "m/d/yy" that on the client's computer, it displays as "m/d/yyyy"?
     
  2. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    I have experienced exactly the same problem, the format has to be on the Form as well as the Table. That should make it show up OK for the Users of the Form.
     
  3. DKTaber

    DKTaber Thread Starter

    Joined:
    Oct 26, 2001
    Messages:
    2,871
    Hi, OBP; long time no talk to. How are things in Wales?

    Don't think that's the problem, because the table was designed before the form, so when the fields were put on the form, they take the format from the table. I checked the form on my computer, and it does indeed show the format as "m/d/yy". I copied both the client and server sides of the split database directly from my computer to theirs, but it is nonetheless displaying "m/d/yyyy".
     
  4. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Cold here in Wales (for us anyway).
    Have you tried putting an Input Mask on the form field to see if that has any effect?
    I suppose you could use VBA to display the data correctly, but you shouldn't have to.
     
  5. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Don, how does the date look in the Query?
    Have also tried formatting in a query?
     
  6. DKTaber

    DKTaber Thread Starter

    Joined:
    Oct 26, 2001
    Messages:
    2,871
    Just turned cold here, too. I hate Winter.

    I have not tried using an input mask and can't do that until I visit their office again. . . because everything works as it should on my computer, just not on theirs.

    The data source is not a query; it's just the table, since the form uses every field in the table.
     
  7. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Well you could take a look at a query to see.
     
  8. DKTaber

    DKTaber Thread Starter

    Joined:
    Oct 26, 2001
    Messages:
    2,871
    Yeah, I could, but I'd have to do it on their computer to see if it makes a difference. Don't know when I'll be there again. Might be as early as end of this week, because things like this bug the sh** out of me, so I'm anxious to find out why it's doing what it's doing.
     
  9. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/965458

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice