After changing fieldtypes from DateTime to DateTime2 I get some error running specific SQL.
MyDateField might also be NULL so I need to check if the record contains a valid date:
Select MyDateField FROM MyTable
WHERE ((IsDate(MyDateField) = 1)
ERROR: Argument data type datetime2 is invalid for argument 1 of isdate function.
I did find this article, but there it doesn't say how to solve this.
How can I correct this SQL so it will work again?
Are there any other issues when switching from DateTime to DateTime2?