Help | Site Map
Connecting Tech Pros Worldwide
 
 
LinkBack Thread Tools
  #1  
Old July 19th, 2005, 09:22 AM
Alfonso Chavez
Guest
 
Posts: n/a
Default Incorrect Date Format

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
  #2  
Old July 19th, 2005, 09:22 AM
Bob Barrows
Guest
 
Posts: n/a
Default Re: Incorrect Date Format

Alfonso Chavez wrote:[color=blue]
> 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[/color]

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

HTH,
Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


 

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over network members.
Post your question now . . .
It's fast and it's free

Popular Articles