F
f
I set the control for an unbound textbox on a form using a
combination of DateDiff and IIf statement:
=DateDiff("d",[Startdate],IIf(IsNull([EndDate]),Date(),[EndDate]))
The control correctly calculates the number of days a
between the startdate and the current date, if there is no
enddate filled in.
The 1st problem is, that the field does not get populated
in the table.
2nd, I need to at different assigned points, have an email
fired off to a specific person, depending on a scheduled
time period. For example, three days before the # of days
reaches 14 day point, I want to send an email to this
person with a message. I do not want to send anything from
the database as an attahment; just the email message itself.
Any ideas?
f -
combination of DateDiff and IIf statement:
=DateDiff("d",[Startdate],IIf(IsNull([EndDate]),Date(),[EndDate]))
The control correctly calculates the number of days a
between the startdate and the current date, if there is no
enddate filled in.
The 1st problem is, that the field does not get populated
in the table.
2nd, I need to at different assigned points, have an email
fired off to a specific person, depending on a scheduled
time period. For example, three days before the # of days
reaches 14 day point, I want to send an email to this
person with a message. I do not want to send anything from
the database as an attahment; just the email message itself.
Any ideas?
f -