
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-09-2009 02:22 PM
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
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
Labels:
- Labels:
-
Archive
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-09-2009 03:21 PM
Take a look at this thread, it should solve your problem : http://www.lansweeper.com/forum/yaf_postst1259p2_Release-35--DATE-format-problem.aspx
