Need help with date calculations

[BigZilla]

In my contacts file I have fields called

[-Queue-]

Make a calculation date field, contact date: Date( Month(purchase date) + contact interval, Day(purchase date), Year(purchase date) ). (This assumes contact interval is always in months.)

When doing your find, use an Insert Calculated Result [contact date, "DateToText( Status(CurrentDate) - DayofWeek( Status(CurrentDate) ) + 2 ) & "..." & DateToText( Status(CurrentDate) ). This will eliminate all weekend dates and only start with Monday of the current week.

[Ugo DI LUCA]

Bill,

One week ago, I tried myself in a test file for just that purpose.

The user wanted several intervals (more than one service per purchase) to be created as soon as a Purchase was entered.

Rather than a fixed date, the result was a WeekofYear, and at opening of the database, the user was presented a list of customers to contact within a range of 1,2,3,4 and 5 weeks, in order to plan an appointment.

The file was also taking into account Week-ends and Holidays, even if the calendar solution provided was very "poor".

Mind thoug, the attachment hasn't been corrected. There's a bug with one duplicated Customer Id. Create 2 or 3 new ones and try yourself.

The file can be found here .