i have problem cannot figure out. sure si simple experts. have sql datetime field populated value of null or 1900-01-01 00:00:00.000. need if statment check both. have tried: isnull, eqaul null, equal nothing, equal "". keep missing value of 1900-01-01 00:00:00.000.
if isnull(mydate) or mydate = "" 'do end if
thank you
i think you're looking #1900-01-01#...
if isnull(mydate) or mydate = "" or mydate = #1900-01-01# 'do end if
Comments
Post a Comment