I have a date/time field. I need to extract just the date in order to do\nfurther date calculations. I created a calculated field using DateValue - but\nif the field does not have a date, it returns #Error. So, I changed it to the\nfollowing: IIF([field] is null,"",DateValue([field])) - this leaves out the\nerror but now changes all the dates to text. A workaround is to have it enter\na 0 rather than leaving it blank, but then that enters the value of 12:00:00\nam. Any other suggestions of how not to have the error display but prevent\nthe dates from changing to text?