dates

[peterbowles]

Hi

I have to fields on a form.
Start Date
End Date
These are dates when a student starts and ends their time at uni.

After a startdate is entered eg. 01/01/00
the end date automaically adds on 6 years
( the time they have to complete the course)

What I need is a field that looks at the current data (realtime)
if the current date is less that 12 months from the Enddate then a msg box will appear informing the user. Then the field will display something like "issue letter" for the purposes of a report.

this one is really important and help would be great

Thanks in advance

 

[pdx_man]

Perhaps in a query you can have a calculated field:

Need_Rpt: IIf(DateDiff('m',Date(),[Enddate]) >= 12, "True","False")

Then, have a report based on this query where the criteria for this field is "True"