Release 3.5 DATE format problem

[wavin]

Hello ,

we just upgrade to 3.5 , premium version.

When I try to put a data in the new custom fields ( purchase data or warranty data ) it works fine if the day is < 12.

If I select 11 March 2009 it works , if I select 13 March 2009 it doesn't work : after pressing "Save Changes" , even if I have the Updated as a result , the record is not updated.

In my opinion is a problem of format of date : when I try to inseret 13/03/2009 in the database is written 03/13/2009 and this is not allowed.

Can you please let me know how can I set the format of the date in Lansweeper website ? I see all date in mm/dd/yyyy , but I'd like to have dd/mm/yyyy which is the settings of my clients and servers.

[wavin]

Hey ,

you are right , those registry keys for those users are wrong !

I changed it manually ( because I don't where to change on W2003 ) and now everything is on the correct format : date and hour.

Thanks for you support

[Hemoco]

Could you check the same registry key for users
"network service"
"IWAM_servername"
"IUSR_servername"

[wavin]

Hello ,

it seems correct , on both servers ( SQL and IIS ) I have :

sShortDate dd/MM/yyyy
sLongDate dddd d MMMM yyyy

but Lansweeper is still on MM/dd/yyyy.....


PS : also the hour format is "wrong". In lansweeper I see the hour in AM/PM while the Italian setting is 24h

[Hemoco]

On your IIS server could you take a look at this registry key please :
HKEY_USERS\.DEFAULT\Control Panel\International

You should see sshortdate, ...

[wavin]

Yes , I can see your demo website with the correct date format.

No SQLserver and IIS are running on 2 separate servers with W2003 running.

[Hemoco]

We tried again reproducing your problem (our format is also dd/mm/yyyy)

Some questions:
When you browse the demo website http://www.lansweeper.com/demo do you see the date correct?
Is your sqlserver/IIS installed on the same server?

[wavin]

Any idea ?

[wavin]

Which settings do you mean ?

Windows "Regional and Language Options" in this server are dd/mm/yyyyy.

Is there any other settings in IIS part ??

[Hemoco]

Could you take a look at the settings of the server where IIS in running please.