Dbnull

[EyeTalion]

job_expiration_date can be null...this code is giving me a DBNULL error...anyone know the proper way i can do this or do I have to write two separate sql statements?

If objDR("job_set_up_date") <= tranPeriod And (objDR("job_expiration_date") >= tranPeriod Or (objDR("job_expiration_date") Is DBNull.Value)) Then

[ggprogram]

I think you should test for null in the statement first, not last.