Substituting Date values with CASE statement
<p>I have a set of records, which contains a Date1 column and a Date2 column. If a record has the Date1 value less than a particular date, then that value will be substituted with the value in the Date2 column for that record.
The Date columns have type date. I'm trying to use a CASE statement but I get the new value for ALL records for some reason.</p>