Easy one for everyone, I should know this answer but am having a brainfart.
I have a variable called startdate. It gets set in a vba loop. At the beginning of the loop, I clear out my variables from the previous record, and set them again, then update my recordset. If it were a string, I would set it = "" in the beginning of the loop, then set it = rs!fieldname. How can I reset a date variable to be null or blank?? Do I have to use those # things?
I have a variable called startdate. It gets set in a vba loop. At the beginning of the loop, I clear out my variables from the previous record, and set them again, then update my recordset. If it were a string, I would set it = "" in the beginning of the loop, then set it = rs!fieldname. How can I reset a date variable to be null or blank?? Do I have to use those # things?
