Handling null dates
Posted on 2008-02-10
I 'm having a rough time handling null dates. I'm pulling data via odbc with a Script Component. I keep getting a Specified Cast is not valid everytime it comes
across a date in the source database that's null. For example, I have a quote table with ClosedDate. If the quote is not closed, this field is null.
I've tried using IsDBNull, and IsDate in an if statement to catch it and set it to 01/01/1900 if the date was null, but it seems to ignore them.
Any help would be greatly appreciated.