MatsHulten
Programmer
I'm developing a site locally on a 2000 Advanced Server running MS SQL Server 2000.
The regional settings shows that the current dateformat is according to Swedish standard (yyyy-MM-dd).
An ASP-script trying to access data from a datetime field in the server populates a variable using FormatDateTime(Now(),2) Witch returns the string "24/04/2001" As far as I can see this is the UK date format.
The same function call executed on the same machine using the debug window in VB returns the string "2001-04-24" wich is the correct Swedish format, that I can execute on the server without it giving me errors.
One of mu collegus run a similar enviroment, and he doesn't run in to this problem...
This seems to be a problem with the settings in the IIS, but i can't find it!
Please help me! I can't simply code around this, as it is code executed in myriad places throughout the scripts...
-Mats Hulten
The regional settings shows that the current dateformat is according to Swedish standard (yyyy-MM-dd).
An ASP-script trying to access data from a datetime field in the server populates a variable using FormatDateTime(Now(),2) Witch returns the string "24/04/2001" As far as I can see this is the UK date format.
The same function call executed on the same machine using the debug window in VB returns the string "2001-04-24" wich is the correct Swedish format, that I can execute on the server without it giving me errors.
One of mu collegus run a similar enviroment, and he doesn't run in to this problem...
This seems to be a problem with the settings in the IIS, but i can't find it!
Please help me! I can't simply code around this, as it is code executed in myriad places throughout the scripts...
-Mats Hulten