Departure Date - Current date will compute the number of days from now til departure
That value divided by the number of documents to send will compute an interval between document emails in days.
A looping script can then loop through found set of records linked to your client record, one record for each document and compute the "send" date for each such record.
I did set up that calculation. That results in the days difference fine, but when I try to divide the result is completely off.
Depart date - Get(CurrentDate) (calculation result is a Number) Works fine.
Depart date - Get(CurrentDate)/ 15 result is way off! The depart date is in a related table (client) does that make a difference? I also understand that if that calculation does work it will give me the proper interval, but how do I get that interval to show up as a date in the "send on date" field?
Basic math problem there. You are dividing the current date by 15 instead of the number of days between dates by 15.
( Depart date - Get(CurrentDate) ) / 15
That will just help teach me to work with no glasses! Sooo obvious!