CREATE TABLE [MCM].[dbo].[showtitl] ( [progtitl] char (20) NOT NULL, [clientid] char (4) NOT NULL, [active] bit NOT NULL, [untcst] numeric (7,2) NOT NULL, [upcst] numeric (7,2) NOT NULL, [upcst2] numeric (7,2) NOT NULL, [opprogtit] char (20) NOT NULL, [clprogtit] char (20) NOT NULL, [clprodid] char (20) NOT NULL, [cluser1] char (20) NOT NULL, [group] char (10) NOT NULL, [actdate] datetime NULL, [inactdate] datetime NULL, [upcst3] numeric (7,2) NOT NULL, [note] text NOT NULL, [progdesc] char (30) NOT NULL, [autophonen] bit NOT NULL, [rtimedmin] numeric (4,0) NOT NULL, [rtimedsec] numeric (3,0) NOT NULL, [rtime] numeric (7,0) NOT NULL, [rtimedesc] char (7) NOT NULL, [dubversion] char (15) NOT NULL, [td_id] char (10) NOT NULL, [budgetamt] numeric (8,0) NOT NULL, [prodcat] char (10) NOT NULL, [plprovided] bit NOT NULL, [modtstamp] numeric (10,0) NOT NULL, [cluntcst] numeric (7,2) NOT NULL, [clupcst] numeric (7,2) NOT NULL, [clupcst2] numeric (7,2) NOT NULL, [clupcst3] numeric (7,2) NOT NULL, [upcst4] numeric (7,2) NOT NULL, [upcst5] numeric (7,2) NOT NULL, [upcst6] numeric (7,2) NOT NULL, [upcst7] numeric (7,2) NOT NULL, [upcst8] numeric (7,2) NOT NULL, [upcst9] numeric (7,2) NOT NULL, [clupcst4] numeric (7,2) NOT NULL, [clupcst5] numeric (7,2) NOT NULL, [clupcst6] numeric (7,2) NOT NULL, [clupcst7] numeric (7,2) NOT NULL, [clupcst8] numeric (7,2) NOT NULL, [clupcst9] numeric (7,2) NOT NULL, [autophfirm] bit NOT NULL, [id] numeric (10,0) NOT NULL, [multibase] bit NOT NULL, [progtshort] char (10) NOT NULL, [campid] char (20) NOT NULL, [sourcetype] char (10) NOT NULL, [dubverenc] char (15) NOT NULL, [stype] char (2) NOT NULL, [altclid] char (4) NOT NULL, [traffnote] text NOT NULL, [upcst10] numeric (7,2) NOT NULL, [upcst11] numeric (7,2) NOT NULL, [upcst12] numeric (7,2) NOT NULL, [upcst13] numeric (7,2) NOT NULL, [upcst14] numeric (7,2) NOT NULL, [upcst15] numeric (7,2) NOT NULL, [upcst16] numeric (7,2) NOT NULL, [upcst17] numeric (7,2) NOT NULL, [upcst18] numeric (7,2) NOT NULL, [upcst19] numeric (7,2) NOT NULL, [upcst20] numeric (7,2) NOT NULL )>Try to change the column type to datetime.