Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
dannyfiasco
Engaged Sweeper
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
1 REPLY 1
Hemoco
Lansweeper Alumni
Take a look at this thread, it should solve your problem : http://www.lansweeper.com/forum/yaf_postst1259p2_Release-35--DATE-format-problem.aspx

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now