Form showing Error in calculated Field

T

Tim

Hello,

I have a form that pulls a date form a query and then
subtracts 2 days form that date, then populates a form.
The field works fine unless there is no current date to
pull. I get #Error in the field. How do I eliminate the
error showing in the form. I have been trying to figure
out how a Null value would work in the form, but I am not
having any sucess with that solution.

This is the code from the form field.
=DateSerial(Year([F2 Due Date]),Month([F2 Due Date]),Day
([F2 Due Date])-2)

Any Ideas are welcome,Thanks.

Tim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top