I have the following query: SELECT COUNT(fldVolunteerID) FROM tbl_volunteer WHERE fldDateDenied IS NOT NULL AND UNIX_TIMESTAMP(fldDateDenied) > UNIX_TIMESTAMP(fldDateApproved) AND fldDenyFlag = 1 and it is not returning the desired output. Problem is that both fldDateDenied and fldDateApproved potentially could be NULL, and I think that is stuffing up my query. What will the effect be of converting a NULL value to UNIX_TIMSTAMP, and then performing a comparison? In the above example: what if fldDateApproved = NULL ? Currently, the query results in a COUNT of 0 (zero), which is not correct (there should be results). All help much appreciated.