Viewing 3 posts - 1 through 4 (of 4 total)
That is good thinking. After playing with it I stumbled upon this and now the DB has NULL in the End Date as it should.
(1) Changed the destination field from...
October 30, 2007 at 9:06 am
thru the query editor. Select *
I changed the destination field from SMALLDATE to varchar just to see and 0000-00-00 appears now.
Really in this table I just have to show that...
October 30, 2007 at 6:45 am
That did work!
but, the NULL values on the prices are now listed as 1899-12-31
which is better than what I had working
October 29, 2007 at 12:28 pm
Viewing 3 posts - 1 through 4 (of 4 total)