Date conversion error

[micki_free]

I am getting an error with a query. specifically when i try to do a date conversion. Access will throw up an exception when a field contains a null value or a value that can not be converted to a date.

I need a way to bypass the conversion of null or other values (the text value of these fields is 'never'). is this possible?

SELECT COUNT(*)
FROM sites_users_and_role
WHERE sites_users_and_role.Service_Type = 'Occasional' AND CDate(Format(CDate([sites_users_and_role.Last_login]), "mm/dd/yyyy")) < #12/01/2008#;

 

[ajetrumpet]

change the statement to an IIF():


IIF(my field IS NULL, "never", cdate(my expression))