Hi,

On my local machine (development machine) when I store date in SQL Server, it stores incorrect value however once the project is upload on to the ISP server, it stores the correct date!

To store date I am usind Format(Date,"yyyy-MM-dd"). For 4 September 2007 it stores 09/04/2007 from the local machine, and 04/09/2007 when the project is uploaded.

I will really appreciate if anyone can help me out.

Best regards,

Tahir

Hi Tahir!!

Have u checked the date format of ur local system??


Cheers :)

vinod

Hi vinod,

It is dd/MM/yyyy. What should it be?

Tahir

hope this link help you
http://support.microsoft.com/kb/173907
http://www.devnewsgroups.net/group/m...opic16289.aspx
http://www.mydatabasesupport.com/for...ql-server.html

Cheers :)

vinod

Hi vinod,

Many thanks. These links were very helpful and resolved my problem.

Tahir