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]

The problem is that, even if I have in the web.config file <add key="dateformat" value="dd/MM/yyyy" /> ,
the date in the web site are in MM/dd/yyyy , as you can see.

This cause an error when I insert a date with day > 12 in the new custom fields .

[wavin]

Hello ,

if I set on the web.config file <add key="dateformat" value="MM/dd/yyyy" />

it works fine , but with English format date.

[wavin]

Hello ,

how can I check the default date settings for the lansweeperuser (sql user) ? I didn't find it .

I'm also not able to post a screenshot with your Message Editor !!!

How can I do it ?

[Hemoco]

wavin wrote:

I'm also not able to post a screenshot with your Message Editor

To post a screenshot click the "attach" button after you made a post.

[Hemoco]

Check the default date settings for the lansweeperuser (sql user)
Please post a screenshot where exactly that you see the wrong dates.

[wavin]

I checked :

- the web.config contain the line <add key="dateformat" value="dd/MM/yyyy" />

- the database server is set ( on the Regional and Laguage Options ) to Italian format dd/mm/yyyy

- the application server ( where LS service run ) is set ( on the Regional and Laguage Options ) to Italian format dd/mm/yyyy

Where is the error ?

Why do I see all date in the website of Lansweeper in mm/dd/yyyy even if the web.config is set to dd/MM/yyyy ??!?!

Is there any other setting that I miss ?!?

[Hemoco]

please edit the web.config file and change line

<add key="dateformat" value="dd/MM/yyyy" />

If this line is already correct the problem is caused by the date settings of your database server