Hi ppl,
I would like to know how to provide condition for Date fields. i wanna do something like this:
i have a field named 'FinishJob' in tableJob (with a drop-down menu with values like "10 days", "14 days", "20 days"). Every job has the field "JobStartDate".
If the JobStartDate is on 20/07/2007 and the 'FinishJob' is 10 days, then the Job has to be completed on 30/07/2007.
I wanna know how to prompt the user abt the Jobs to be finished within 5 days.
When i Press a Button "Check for Job List", it should list all the jobs which are to be completed within the next five days.
Could anyone assist me in this regard.
thanks,
Kathy