#Error in Empty Date field
In a database for Disciplinary Hearings, where the ValidityEndDate is calculated depending on the entry in WarningType and thus NoMonths and the entry in ValidityStartDate.
If there is a date entered in ValidityStartDate it works perfectly.
When there is no entry in the field, ValidityStartDate, this causes #Error to be displayed in the field ValidityEndDate. I donít want that #Error to be displayed. I understand that the problem exists because of multiplying by zero, but I need to know how to resolve it e.g. with Conditional Formatting if all else fails.
My criteria for the calculated query field (ValidityEndDate) are as follows:
Thank you in anticipation.