Friday's Due Date

[RRS]

Every Friday, I run an error report which searches for errors with an
Audit_Date between last Friday (a week ago) and Thursday (the day before the
report is run). Since the reports must be signed and management wants them
returned by the following Friday, I've been asked to put a due date on the
report. Additionally, since the Audit_Date varies and the automated report
can be printed by others at anytime, how do I get the due date to always
appear as the second Friday after the Audit_Date? I've tried several date
functions, but I'm not having any luck. Please assist. Thank you!!!

 

[John W. Vinson]

Every Friday, I run an error report which searches for errors with an
Audit_Date between last Friday (a week ago) and Thursday (the day before the
report is run). Since the reports must be signed and management wants them
returned by the following Friday, I've been asked to put a due date on the
report. Additionally, since the Audit_Date varies and the automated report
can be printed by others at anytime, how do I get the due date to always
appear as the second Friday after the Audit_Date? I've tried several date
functions, but I'm not having any luck. Please assist. Thank you!!!

 

[John W. Vinson]

Every Friday, I run an error report which searches for errors with an
Audit_Date between last Friday (a week ago) and Thursday (the day before the
report is run). Since the reports must be signed and management wants them
returned by the following Friday, I've been asked to put a due date on the
report. Additionally, since the Audit_Date varies and the automated report
can be printed by others at anytime, how do I get the due date to always
appear as the second Friday after the Audit_Date? I've tried several date
functions, but I'm not having any luck. Please assist. Thank you!!!

You can use a mix of date functions to get this:

DateAdd("d", 13-Weekday([Audit_Date]), [Audit_Date])