Date confusion

Hi,

I am developing a webpage in conjunction with MS access. I use dates as a
primary attribute to search for data. However, on somedays the program will
work with the date format mm/dd/yyyy and other times it is dd/mm/yyyy and
sometimes it will work with both. When it works with both this causes the
most confusion. In some parts of the program the application will work with
the mm/dd/yyyy format and some other parts with dd/mm/yyyy. However other
parts of the program will crash because it is of the wrong format.

My question is... Is there some way of making it conssitent throughout the
application? My regional settings is set to Australia.

Thanks in Advance

Nic
Thu Jul 21 03:25:40 CDT 2005

> However, on somedays the program will
> work with the date format mm/dd/yyyy and other times it is dd/mm/yyyy and
> sometimes it will work with both.

Is this on the same box?
Is this with the same login account?
Is the problem only to do with access formatting or does scripting exhibit
the same behaviour?

Nic Roche

"panda" <panda@discussions.microsoft.com> wrote in message
news:B057DB84-BA7F-4548-ADD4-DB635C7DE9D1@microsoft.com...
> Hi,
>
> I am developing a webpage in conjunction with MS access. I use dates as a
> primary attribute to search for data. However, on somedays the program
> will
> work with the date format mm/dd/yyyy and other times it is dd/mm/yyyy and
> sometimes it will work with both. When it works with both this causes the
> most confusion. In some parts of the program the application will work
> with
> the mm/dd/yyyy format and some other parts with dd/mm/yyyy. However other
> parts of the program will crash because it is of the wrong format.
>
> My question is... Is there some way of making it conssitent throughout the
> application? My regional settings is set to Australia.
>
> Thanks in Advance

panda
Thu Jul 21 04:47:06 CDT 2005

Hi,

What i have is a calender system whereby the user selects a day to make a
booking. This leads to another page where the user puts in the details and
then saves it. later on when the user edits the booking the problem arises. i
am using dd/mm/yyyy. but the last ones requires mm/dd/yyyy

any way to fix this?

"Nic Roche" wrote:

> > However, on somedays the program will
> > work with the date format mm/dd/yyyy and other times it is dd/mm/yyyy and
> > sometimes it will work with both.
>
> Is this on the same box?
> Is this with the same login account?
> Is the problem only to do with access formatting or does scripting exhibit
> the same behaviour?
>
> Nic Roche
>
> "panda" <panda@discussions.microsoft.com> wrote in message
> news:B057DB84-BA7F-4548-ADD4-DB635C7DE9D1@microsoft.com...
> > Hi,
> >
> > I am developing a webpage in conjunction with MS access. I use dates as a
> > primary attribute to search for data. However, on somedays the program
> > will
> > work with the date format mm/dd/yyyy and other times it is dd/mm/yyyy and
> > sometimes it will work with both. When it works with both this causes the
> > most confusion. In some parts of the program the application will work
> > with
> > the mm/dd/yyyy format and some other parts with dd/mm/yyyy. However other
> > parts of the program will crash because it is of the wrong format.
> >
> > My question is... Is there some way of making it conssitent throughout the
> > application? My regional settings is set to Australia.
> >
> > Thanks in Advance
>
>
>

McKirahan
Thu Jul 21 05:29:33 CDT 2005

"panda" <panda@discussions.microsoft.com> wrote in message
news:2D15C56C-06E6-4842-A0DA-3D363710950A@microsoft.com...
> Hi,
>
> What i have is a calender system whereby the user selects a day to make a
> booking. This leads to another page where the user puts in the details and
> then saves it. later on when the user edits the booking the problem
arises. i
> am using dd/mm/yyyy. but the last ones requires mm/dd/yyyy
>
> any way to fix this?
>

[snip]

If your dates are in DateTime fields, try using "yyyymmdd" format.

Bob
Thu Jul 21 06:17:45 CDT 2005

panda wrote:
> Hi,
>
> I am developing a webpage in conjunction with MS access. I use dates
> as a primary attribute to search for data. However, on somedays the
> program will work with the date format mm/dd/yyyy and other times it
> is dd/mm/yyyy and sometimes it will work with both. When it works
> with both this causes the most confusion. In some parts of the
> program the application will work with the mm/dd/yyyy format and some
> other parts with dd/mm/yyyy. However other parts of the program will
> crash because it is of the wrong format.
>
> My question is... Is there some way of making it conssitent
> throughout the application? My regional settings is set to Australia.
>
http://www.aspfaq.com/show.asp?id=2040

http://www.aspfaq.com/show.asp?id=2313

http://www.aspfaq.com/show.asp?id=2260

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"