Due data control in form

[Judy]

I have placed a control in a form to calculate a due date based on a start
date I enter in a field. My problem is if there isn't a date in the start
date field, my due date field displays #Error. Here's my formula:

=DateSerial(Year([CollabStartDate]),Month([CollabStartDate]),Day([CollabStartDate])+15)

Is there a way to make it not show the #Error until I have a date to enter
in the start date field?
I have 4 different due dates in my form, tracking the due dates of the
various phases of the project: review, edit, collaboration, approval, so the
start dates for each of activities don't get entered until the previous phase
has completed. Ideally, I'd also like to get notified when a due date has
arrived; haven't figured that one out at all yet.

Thanks for any help.

 

[Allen Browne]

Try one of these:
=[CollabStartDate] + 15
=DateAdd("d", 15, [CollabStartDate])

I think that would be better than:
= IIf(IsDate([CollabStartDate], DateSerial( ... ), Null)

 

[Judy]

Thank you so much. I now have it working in my form. Now, I need to figure
out how to notify myself with a report (I guess) listing the documents that
are due back from collaboration,when I open my database every day.

Thanks for your continued help.

Try one of these:
=[CollabStartDate] + 15
=DateAdd("d", 15, [CollabStartDate])

I think that would be better than:
= IIf(IsDate([CollabStartDate], DateSerial( ... ), Null)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have placed a control in a form to calculate a due date based on a start
date I enter in a field. My problem is if there isn't a date in the start
date field, my due date field displays #Error. Here's my formula:

=DateSerial(Year([CollabStartDate]),Month([CollabStartDate]),Day([CollabStartDate])+15)

Is there a way to make it not show the #Error until I have a date to enter
in the start date field?
I have 4 different due dates in my form, tracking the due dates of the
various phases of the project: review, edit, collaboration, approval, so
the
start dates for each of activities don't get entered until the previous
phase
has completed. Ideally, I'd also like to get notified when a due date has
arrived; haven't figured that one out at all yet.

Thanks for any help.

 

[Allen Browne]

Now that you have the query returning the right records, you can use it as
the source for a report.

Then it's a matter of creating a macro named AutoExec, with the OpenReport
action.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thank you so much. I now have it working in my form. Now, I need to figure
out how to notify myself with a report (I guess) listing the documents
that
are due back from collaboration,when I open my database every day.

Thanks for your continued help.

Try one of these:
=[CollabStartDate] + 15
=DateAdd("d", 15, [CollabStartDate])

I think that would be better than:
= IIf(IsDate([CollabStartDate], DateSerial( ... ), Null)