VBScript handing a sql value of 1900-01-01 00:00:00.000 -


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