I am trying to right a computed column in sql 2008 to set a bit field to true when a date in one column s older than a date in another column and a furtther bit field is set to true
I got as far as trying to compare the dates, like so:
SELECT CASE WHEN DateCreated < ScheduledStart THEN '1'ELSE '0'END
But I kept getting an error when trying to enter the formula. What am I doing wrong?