update generalbookingitem set date = convert(datetime, '01/01/2007', 1), enddate = convert(datetime, '31/12/2007', 1) where biid='A-1/2007/1'