I have a problem that I cannot figure out. I am sure it si simple for the experts. I have a sql datetime field that is populated with a value of NULL or 1900-01-01 00:00:00.000. I just need an if statment to check for both. I have tried: isNUll, eqaul to null, equal to nothing, equal to "". But t开发者_JS百科hey keep missing the value of 1900-01-01 00:00:00.000.
If IsNull(MyDate) or MyDate = "" then
'Do Something
end if
Thank you
I think you're just looking for #1900-01-01#...
If IsNull(MyDate) or MyDate = "" or MyDate = #1900-01-01# Then
'Do Something
End If
精彩评论