Error values with date fields

[Pete_(Guest)]

I have some reports that involve calculating from a date field in Excel using the ADDYRS or IIF function. In some cases the excel field is empty resulting in the string of ****. I have tried using the "ERROR" function to no avail. The only way I have been able to subsitute a text entry for the asterisks is to convert the date fields to characters (DTOC)and then use the ERROR function. Am I missing something?

[kfleming]

You can certainly test date calculations using the error function ____ERROR(adddays(hiredate,5))____will return a true or false value depending on whether hiredate contains a valid date field.____Kathleen__R&R Support