If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Friday's Due Date
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!!! |
#2
|
|||
|
|||
Friday's Due Date
RRS wrote:
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!!! use DateDiff. You can specify the current date, which is Date() and then add any increment of time to it. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201005/1 |
#3
|
|||
|
|||
Friday's Due Date
On Fri, 14 May 2010 01:39:01 -0700, RRS wrote:
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 [MVP] |
#4
|
|||
|
|||
Friday's Due Date
On Fri, 14 May 2010 01:39:01 -0700, RRS wrote:
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]) -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|