Incorrect Date Format

[Alfonso Chavez]

Hi Everybody,

I hope this is the correct newsgroup for this, if not
please let me know where should i send this question which
is driving me crazy.

The problem is the FormatDateTime function it is changing
the date format to MM/dd/yyyy but we need dd/MM/yyyy. We
already changed the regional settings for the
administrator user. Access the regedit tool and change the
format to dd/MM/yyy on all the users on the server but we
are still getting the incorrect format.

First we got for every case the format switch. For example
we ask for this FormatDateTime("01/10/2003",2) Octuber
1st, 2003 an the result was "10/01/2003" January 10th, 2003
for days lower than the 12th and even if we send
FormatDateTime("31/10/2003", 2) we got "10/31/2003"

After some changes this is what is happening know
FormatDateTime("01/10/2003", 2) -- > 10/01/2003
FormatDateTime("31/10/2003", 2) -- > 31/10/2003

The server is running Windows 2000 Advanced Server with
IIS 5.0

Thanks for your help on this matter

Alfonso Chavez

 

[Bob Barrows]

Hi Everybody,

I hope this is the correct newsgroup for this, if not
please let me know where should i send this question which
is driving me crazy.

The problem is the FormatDateTime function it is changing
the date format to MM/dd/yyyy but we need dd/MM/yyyy. We
already changed the regional settings for the
administrator user. Access the regedit tool and change the
format to dd/MM/yyy on all the users on the server but we
are still getting the incorrect format.

First we got for every case the format switch. For example
we ask for this FormatDateTime("01/10/2003",2) Octuber
1st, 2003 an the result was "10/01/2003" January 10th, 2003
for days lower than the 12th and even if we send
FormatDateTime("31/10/2003", 2) we got "10/31/2003"

After some changes this is what is happening know
FormatDateTime("01/10/2003", 2) -- > 10/01/2003
FormatDateTime("31/10/2003", 2) -- > 31/10/2003

The server is running Windows 2000 Advanced Server with
IIS 5.0

Thanks for your help on this matter

Alfonso Chavez

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

HTH,
Bob Barrows