Dates and Access

  • Thread starter Thread starter acs68
  • Start date Start date
A

acs68

Hi all,

Have a question regarding Dates in Access

O have a form and users have been inputting dd/mm and it has been defaulting
to the Year 2029

Is this due to Regional Settings (using XP Pro) ?

What is the best way to handle dates in forms so that it doesn't matter what
the users Regional Settings are set at ?

thanks in advance,

Adam
 
acs68 said:
Hi all,

Have a question regarding Dates in Access

O have a form and users have been inputting dd/mm and it has been
defaulting to the Year 2029

Is this due to Regional Settings (using XP Pro) ?

What is the best way to handle dates in forms so that it doesn't
matter what the users Regional Settings are set at ?
Click to expand...

The best way to handle dates is to have users enter full dates meaning a month,
day, and a four digit year. You can explicitly set formatting options to
*display* dates in a way that ignores regional settings, but I don't know of a
way to manipulate the assumptions Access will make when only a partial date is
entered.

You could use an unbound control for data entry and use AfterUpdate code to take
that entry and produce a date value for insertion into the table and then have
complete control over how that conversion is done.
 
I've been using Access since it first came out and it has NOT ONCE helped me
get a date.
 
Hi all,

Have a question regarding Dates in Access

O have a form and users have been inputting dd/mm and it has been defaulting
to the Year 2029

Is this due to Regional Settings (using XP Pro) ?
Click to expand...

In my experience, it enters the current year (by the system clock) if
you just type days and months. Do you mean that if you type

04/05

into a textbox bound to a Date/Time field it stores April 5, 2029? I'd
expect it to store April 5, 2005.
What is the best way to handle dates in forms so that it doesn't matter what
the users Regional Settings are set at ?
Click to expand...

Enter dates unambiguously, e.g. type in

05-Apr-2005


John W. Vinson[MVP]
 
Back
Top