Re: Date confusion

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"


.

Relevant Pages

  • Date Time Problem
    ... My dates are stored in the format MM/dd/yyyy hh:mm:ss ... I have been able to get the correct format to appear in an update form by ... Now I want to be able to input the date as dd/MM/yyyy in my form and have it ...
    (microsoft.public.dotnet.general)
  • Re: Comparing SQL Server and User dates
    ... > dd/mm/yyyy or mm/dd/yyyy and when comparing it gives error. ... >> - Use some sort of calendar script so there can be no ambiguity ... > dates in dd/mm/yyyy what ever the system format and again if system format ... >>> dates in SQL server and thankful to them who replied. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Date problem (need to use DD MM YYYY instead of MM DD YYYY (Australia)
    ... you can use the Aussie/British format of dd/mm/yyyy by ... defining that in the Windows Control Panel under Regional Settings. ... However, in a SQL clause, you must use the American format mm/dd/yyyy. ...
    (microsoft.public.access.queries)
  • Re: Date format error
    ... you cannot format the date as dd/mm/yyyy and expect it to work reliably. ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Date problem
    ... Your dates are NOT being "stored in UK dd/mm/yyyy ... dates MUST be in mm/dd/yyyy format, regardless of what your Short Date ... The date is then entered in a new or modified record in another ...
    (microsoft.public.vb.database)