REQ HELP: Date Format Mysteriously Changed Globally to Four Digit Year

[MHenry]

Hi,

I don't know what happened, but all the MS Access dates in all tables,
queries, forms, and reports in all databases suddenly show on my
computer with the year as 4 digits (including network databases I
access on my computer). It used to always be 2 digits.

I have been changing the format of dates in all my databases tables,
queries, forms, and reports to mm/dd/yy and that was working for a
while. But today, the reports I made this change would no longer open
in design more or report mode.

Even when it works, this method is tedious and time-consuming.

If someone knows how to fix this, will they please let me know?

MHenry

[Rick Brandt]

Re: REQ HELP: Date Format Mysteriously Changed Globally to Four Digit Year

"MHenry" <MHenry@NoSpam. net> wrote in message
news:sp3090png0 ap1lqv7ot0grr0e k1shlhn9h@4ax.c om...[color=blue]
> Hi,
>
> I don't know what happened, but all the MS Access dates in all tables,
> queries, forms, and reports in all databases suddenly show on my
> computer with the year as 4 digits (including network databases I
> access on my computer). It used to always be 2 digits.
>
> I have been changing the format of dates in all my databases tables,
> queries, forms, and reports to mm/dd/yy and that was working for a
> while. But today, the reports I made this change would no longer open
> in design more or report mode.
>
> Even when it works, this method is tedious and time-consuming.
>
> If someone knows how to fix this, will they please let me know?[/color]

If you use a *named* format (short, medium, long, currency, etc.), then
Access uses the definitions of these as set in the Windows Regional
Settings of Control Panel. My guess is that your regional setting was
recently changed.

If you use a format property string (mm/dd/yy, yyyy-m-d, #0.00, etc.) then
they should always be honored regardless of regional settings.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Lyle Fairfield]

Re: REQ HELP: Date Format Mysteriously Changed Globally to Four Digit Year

MHenry <MHenry@NoSpam. net> wrote in news:sp3090png0 ap1lqv7ot0grr0e k1shlhn9h@
4ax.com:
[color=blue]
> I don't know what happened, but all the MS Access dates in all tables,
> queries, forms, and reports in all databases suddenly show on my
> computer with the year as 4 digits (including network databases I
> access on my computer). It used to always be 2 digits.[/color]

Give thanks!
[color=blue]
> I have been changing the format of dates in all my databases tables,
> queries, forms, and reports to mm/dd/yy and that was working for a
> while.[/color]

That's incredible.
[color=blue]
> But today, the reports I made this change would no longer open
> in design more or report mode.[/color]

Access is a just program.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[MHenry]

Re: REQ HELP: Date Format Mysteriously Changed Globally to Four Digit Year

Thank you, Rick.

I changed my short date to the way I wanted it in my Regional
Settings. All is well in Smallville again.
I have no idea how it got changed, but I guess it must have.
Maybe some program I recently installed did it?
Actually, I have updated a couple of programs. bit installed no new
programs.
Maybe it could have been a Windows Update?
If so, I guess some other people would have the same problem.

MHenry


On Wed, 28 Apr 2004 15:44:24 -0500, "Rick Brandt"
<rickbrandt2@ho tmail.com> wrote:
[color=blue]
>"MHenry" <MHenry@NoSpam. net> wrote in message
>news:sp3090png 0ap1lqv7ot0grr0 ek1shlhn9h@4ax. com...[color=green]
>> Hi,
>>
>> I don't know what happened, but all the MS Access dates in all tables,
>> queries, forms, and reports in all databases suddenly show on my
>> computer with the year as 4 digits (including network databases I
>> access on my computer). It used to always be 2 digits.
>>
>> I have been changing the format of dates in all my databases tables,
>> queries, forms, and reports to mm/dd/yy and that was working for a
>> while. But today, the reports I made this change would no longer open
>> in design more or report mode.
>>
>> Even when it works, this method is tedious and time-consuming.
>>
>> If someone knows how to fix this, will they please let me know?[/color]
>
>If you use a *named* format (short, medium, long, currency, etc.), then
>Access uses the definitions of these as set in the Windows Regional
>Settings of Control Panel. My guess is that your regional setting was
>recently changed.
>
>If you use a format property string (mm/dd/yy, yyyy-m-d, #0.00, etc.) then
>they should always be honored regardless of regional settings.[/color]

[Rick Brandt]

Re: REQ HELP: Date Format Mysteriously Changed Globally to Four Digit Year

"MHenry" <MHenry@NoSpam. net> wrote in message
news:lne090p6fr k09u8srmj36iadk 4n1ke0c28@4ax.c om...[color=blue]
> Thank you, Rick.
>
> I changed my short date to the way I wanted it in my Regional
> Settings. All is well in Smallville again.
> I have no idea how it got changed, but I guess it must have.
> Maybe some program I recently installed did it?
> Actually, I have updated a couple of programs. bit installed no new
> programs.
> Maybe it could have been a Windows Update?
> If so, I guess some other people would have the same problem.[/color]

That's why if you really care you should avoid the named constants. If your
app is used by others the format will follow whatever their regional
settings are. Why would you want a 2 digit year anyway? Did you forget
about that mess a while back already :-)

[MHenry]

Re: REQ HELP: Date Format Mysteriously Changed Globally to Four Digit Year

On Wed, 28 Apr 2004 21:24:21 -0500, "Rick Brandt"
<rickbrandt2@ho tmail.com> wrote:
[color=blue]
>"MHenry" <MHenry@NoSpam. net> wrote in message
>news:lne090p6f rk09u8srmj36iad k4n1ke0c28@4ax. com...[color=green]
>> Thank you, Rick.
>>
>> I changed my short date to the way I wanted it in my Regional
>> Settings. All is well in Smallville again.
>> I have no idea how it got changed, but I guess it must have.
>> Maybe some program I recently installed did it?
>> Actually, I have updated a couple of programs. bit installed no new
>> programs.
>> Maybe it could have been a Windows Update?
>> If so, I guess some other people would have the same problem.[/color]
>
>That's why if you really care you should avoid the named constants. If your
>app is used by others the format will follow whatever their regional
>settings are. Why would you want a 2 digit year anyway? Did you forget
>about that mess a while back already :-)[/color]

Hi, Rick,

I gave a passing thought to the Y2K hoopla as I muddled through this,
but my reasons for wanting 2 year display are for space and
consistency. I have many columns in my tables and subforms and I like
to see as many of the columns as possible without scrolling. I had to
increase my column widths to see the full date when it switched to
four digits. The chance for confusion in dates is slight as my
databases are rather small, limited to my clients and their financial
activities.[color=blue]
>
>[/color]