Results 1 to 9 of 9
  1. #1
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts

    date format on form (2007)

    I have a date picking form for setting the date range for reports on a client's database. They are using Access 2007 but the database format is 2000. On the workstation I was using yesterday to install some updated reports, I noticed the date picker was displaying dates as yy-mm-dd even though the textbox specifies medium date. I checked regional settings and they are correct. Besides, they don't handle medium date format anyways. As far as I know, it is just the one workstation. Any ideas where to look?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: date format on form (2007)

    I have no idea what causes this, but try specifying the date format explicitly as dd-mmm-yyyy instead of as Medium Date.

  3. #3
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: date format on form (2007)

    Thanks Hans. I don't really want to go to that trouble as it seems to be only the one workstation and the code in the on click event gets modified quite regularly. If it does appear to be a problem on others, I will follow your advice. I'm sure this user has some weird setting somewhere that is causing this and I wouldn't be at all surprised if it is somewhere in the bowels of Access 2007.

    Thanks

  4. #4
    2 Star Lounger
    Join Date
    May 2002
    Location
    Jerusalem, Israel
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am also having problems with the date picker in my Access 2007 database. All of a sudden the dates do not display correctly.

    At the table level and at the form level I specified the date format as dd-mmm-yyyy, as suggested (the format was "Medium Date"). The dates DO display in that format, but backwards. For example, if I was to pick 5 July 2009 from the date picker, the format would be correct, but the date would display as 7 May 2009.

    Since this is a new bug that somehow introduced itself into the DB, I did a compact and repair on both the front and back ends, but that didn't work.

    Any ideas on what I might try next?

    Thanks,

    JoeK

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I don't think compacting the database would help here. It appears there's confusion between US and European date formats. How do you process the date selected by the user?

  6. #6
    2 Star Lounger
    Join Date
    May 2002
    Location
    Jerusalem, Israel
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='783088' date='05-Jul-2009 14:28']I don't think compacting the database would help here. It appears there's confusion between US and European date formats. How do you process the date selected by the user?[/quote]

    I am not sure what you mean by "process the date". The date is stored in a bound field - is that what you mean?

    BTW, when you mentioned US and European date formats, it reminded me to check the regional settings on my PC. Lo and behold, I had the US format set as the date format. I changed it to dd-MMM-yyyy and now the dates in my DB work the way I want them to.

    I would have thought that you would be able to override the PC's regional settings because multiple users have different settings and I can't ask them all to change their own preferences. I did make sure that the field format is dd-MMM-yyyy, but that didn't seem to help at all.

    If I type the date directly into the field, I don't have any problems. Maybe it's just the way the date-picker works...Maybe I have to use a customized date-picker and not the built in one...?

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Do you mean that the Date/Time Picker control is bound directly to a field? If so, the problem might be specific to Access 2007, but I don't use that version so I know very little about it.

  8. #8
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Hong Kong
    Posts
    359
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='PeterN' post='695189' date='16-Feb-2008 07:04']I have a date picking form for setting the date range for reports on a client's database. They are using Access 2007 but the database format is 2000. On the workstation I was using yesterday to install some updated reports, I noticed the date picker was displaying dates as yy-mm-dd even though the textbox specifies medium date. I checked regional settings and they are correct. Besides, they don't handle medium date format anyways. As far as I know, it is just the one workstation. Any ideas where to look?[/quote]
    Hi Peter,
    Is it SP2 of Access 2007 (12.0.6423.1000)?
    Armstrong

  9. #9
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Hong Kong
    Posts
    359
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='joek' post='783083' date='05-Jul-2009 19:05']I am also having problems with the date picker in my Access 2007 database. All of a sudden the dates do not display correctly.

    At the table level and at the form level I specified the date format as dd-mmm-yyyy, as suggested (the format was "Medium Date"). The dates DO display in that format, but backwards. For example, if I was to pick 5 July 2009 from the date picker, the format would be correct, but the date would display as 7 May 2009.

    Since this is a new bug that somehow introduced itself into the DB, I did a compact and repair on both the front and back ends, but that didn't work.

    Any ideas on what I might try next?

    Thanks,

    JoeK[/quote]
    1. What's your Windows regional setting?
    2. Has you set the Input Mask for the date field (table)?
    3. If you set Default Value to Date() or Now(), does it display correctly?
    4. Is Hebrew used as the default language?

    Armstrong

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •