A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Friday's Due Date



 
 
Thread Tools Display Modes
  #1  
Old May 14th, 2010, 09:39 AM posted to microsoft.public.access.queries
RRS
external usenet poster
 
Posts: 8
Default 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  
Old May 14th, 2010, 01:41 PM posted to microsoft.public.access.queries
PieterLinden via AccessMonster.com
external usenet poster
 
Posts: 307
Default 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  
Old May 14th, 2010, 07:51 PM posted to microsoft.public.access.queries
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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  
Old May 14th, 2010, 07:55 PM posted to microsoft.public.access.queries
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:31 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.