I have a database containing clients with different service schedules (Monthy, Quarterly, etc) I need to calculate the next service date based on their service schedule and an effective date. Any suggestions would be helpful.
Help - DateAdd problem
- Thread starter apugh1971
- Start date
Yes. I have a separate table containing the service schedules. When entering the service schedule for each client. The field is linked as a combo box to my service schedule table. The effective date is different for each client
Mile-O
Back once again...
- Local time
- Today, 22:31
- Joined
- Dec 10, 2002
- Messages
- 11,305
I'd add two extra fields: Duration and Period
Duration would store numbers
Period would store text representations of date periods (d, m, yyyy, q, etc)
In a query, you can use DateAdd([Period], [Duration], datefield) to get the date you want.
Duration would store numbers
Period would store text representations of date periods (d, m, yyyy, q, etc)
In a query, you can use DateAdd([Period], [Duration], datefield) to get the date you want.
