Notification based on a date (1 Viewer)

[MGF23]

Ey'up!

I have a date field: START DATE and END DATE. If the difference between the two dates is greater than or equal to 7 days, i need a notification to appear on the form (maybe in an adjacent text box) that says something like "REPORT TO EXTERNAL AUTHORITY"

If the condition is not met then the text box could be left blank or present a cursory message like "no further action".

any pointers would be greatly appreciated.

 

[theDBguy]

Hi. You could try using an unbound Textbox and just format it to look like a Label. Set the Enabled property to No and the Loked property to Yes. Then in the Control Source, try some like this.

=IIf(Datediff("d", [Start Date], [End Date])>=7,"Report to External Authority","No report needed")

Hope that helps...

 

[Gasman]

Look at the DateDiff() function.