Prev: Lag 1 day relationship
Next: query trouble
From: RRS on 14 May 2010 04:39 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!!!
From: PieterLinden via AccessMonster.com on 14 May 2010 08:41 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/Forums.aspx/access-queries/201005/1
From: John W. Vinson on 14 May 2010 14:51 On Fri, 14 May 2010 01:39:01 -0700, RRS <RRS(a)discussions.microsoft.com> 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]
From: John W. Vinson on 14 May 2010 14:55 On Fri, 14 May 2010 01:39:01 -0700, RRS <RRS(a)discussions.microsoft.com> 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]
|
Pages: 1 Prev: Lag 1 day relationship Next: query trouble |