Re: ADO, ShortDateFormat and Terminal Services/Citrix

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Isaac Alexander wrote:
It gets it from the Registry Regional Settings.
It's a mistake to have varying date formats. Formats should only be
involved when displaying dates to users. You should not be leaving
it up to ADO to properly interpret the dates provided by your
program. Users should be provided controls (calendar controls) to
allow them to supply dates to you in a standard format. Dates being
handled in your program should be format-insensitive: e.g., VB uses
doubles to represent date-times.


Thank you for you comments, but my app isn't changing the
ShortDateFormat, it's simply reading it. All date show up in whatever
format the regional settings show.

The reason it matters is because locallized filter strings need to be
in short date format (at least with Delphi).

So why don't you format them to be that way? Why are you depending on what
the machine's settings are?
--
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

  • Re: Date and Time
    ... datetimes are not stored with any format. ... The first integer contains the number of days since the seed date. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Date confusion
    ... > 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. ... > program the application will work with the mm/dd/yyyy format and some ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: Problem with ASP/Access DB
    ... I'm using the following SQL Statementbut i won't work. ... use the YYYY-MM-DD format. ... Personally, I prefer using stored procedures, or saved parameter queries ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Finding block begin/end in VBScript
    ... I never used it (Format() was so handy) so I forgot it was there. ... the Execute method definitely was not in VB/VBA (I checked the docs ... Bob Barrows ... This email account is my spam trap so I ...
    (microsoft.public.vsnet.ide)
  • Re: regexp pattern help
    ... But can you make a pattern that "knows" how many days a certain month has? ... Just using the IsDate function wouldn't be enough in this case since you can ... But my app only alows the exact format, ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)