Prev: Does it possible to merge these DB's
Next: Send different reports to different printers
From: Julie Gilliam on 16 Feb 2010 12:48
I need a completion date to always fall on a Friday if the completion date is
a Saturday or Sunday. Can someone please give me the correct formula to
enter to get the results like this. I have to use a formula to add 90 days
from last completion date and I achieve this by saying [Completion Date]+90
but I need to add something else to the formula so if it falls on a Weekend
Day it defaults back to Friday. I have been trying several years to get this
accomplished. (Before I was aware of this great help) Thanks Julie
From: Gary on 16 Feb 2010 12:57
Your simplest answer is to add 91 dayx. (That's divisible by 7.) You'll still have to manually check for NY, Xmas & other holidays.

---
frmsrcurl: http://msgroups.net/microsoft.public.access.reports/Completion-Date
 | 
Pages: 1
Prev: Does it possible to merge these DB's
Next: Send different reports to different printers