We try to insert the PurchaseDate and WarrantyDate by script to the Database, running following sql-statement for example:
INSERT INTO [lansweeperdb].[dbo].[tblCompCustom]
([Computername] ,[PurchaseDate] ,[Warrantydate],[State],[LastChanged])
VALUES('JZ5J34J' ,'30.06.2008','8.12.2011',1 ,'09.06.2009')
the values are inserted correctly but when lookin to the Lansweeper Web Console the date is shown like 30.06.2008.
Clicking to the calendar-symbol right next to the date tells me:
Invalid date: '30.06.2008'.
Accepted format is dd/mm/yyyy.
when i now replace the "." on the website by "/" and click "Save changes" the calendar symbol is working. But when i take a look to the database there is no difference.
Any idea?
thank you very much and brgds
Daniel