=DateAdd() Function

[Charles Phillips]

Hello,
I developed a form in MS-Access 97 with the following fields:

1. Date Shipped Back To User (DateShippedBackToUser)

2. Follow UpDate (FollowUpDate)

3. Date Package Arrived (DatePackageArrived)

#1 sets the stage for #2 and #3.
I manually enter the date for #1
ALL packages are shipped overnight.

#2 is: Follow Up Date =DateAdd("d",3,[DateShippedBackToUser])

#3 is the same as #2, but I want the fnc to bypass weekend dates, and put
the following Monday date in the field.

Can someone point me in the right direction???


Thank you,

Charles L. Phillips

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/datetime/date0012.htm at "The
Access Web"

 

[Charles Phillips]

Hello,
"Thank You".
I'll read this & apply/modify this process over the weekend...


Thank you,

Charles L. Phillips

Take a look at http://www.mvps.org/access/datetime/date0012.htm at "The
Access Web"

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hello,
I developed a form in MS-Access 97 with the following fields:

1. Date Shipped Back To User (DateShippedBackToUser)

2. Follow UpDate (FollowUpDate)

3. Date Package Arrived (DatePackageArrived)

#1 sets the stage for #2 and #3.
I manually enter the date for #1
ALL packages are shipped overnight.

#2 is: Follow Up Date =DateAdd("d",3,[DateShippedBackToUser])

#3 is the same as #2, but I want the fnc to bypass weekend dates, and put
the following Monday date in the field.

Can someone point me in the right direction???


Thank you,

Charles L. Phillips

 

[Charles Phillips]

Hello,
When you're a NEWBIE like myself, how do you know or where to look for
reference materials???
I have several books, but the books do not cover some of the information I
need. I'd like to build a reference list (library), so I don't have to ask
so many simple questions...

Thank you,

Charles L. Phillips

Hello,
"Thank You".
I'll read this & apply/modify this process over the weekend...


Thank you,

Charles L. Phillips

Take a look at http://www.mvps.org/access/datetime/date0012.htm at "The
Access Web"

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hello,
I developed a form in MS-Access 97 with the following fields:

1. Date Shipped Back To User (DateShippedBackToUser)

2. Follow UpDate (FollowUpDate)

3. Date Package Arrived (DatePackageArrived)

#1 sets the stage for #2 and #3.
I manually enter the date for #1
ALL packages are shipped overnight.

#2 is: Follow Up Date =DateAdd("d",3,[DateShippedBackToUser])

#3 is the same as #2, but I want the fnc to bypass weekend dates, and
put the following Monday date in the field.

Can someone point me in the right direction???


Thank you,

Charles L. Phillips

 

[Douglas J. Steele]

The Access Web http://www.mvps.org/access/ is always a good place to start.

Also, take a look at what Jeff Conrad has at
http://home.bendbroadband.com/conradsystems/accessjunkie.html

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hello,
When you're a NEWBIE like myself, how do you know or where to look for
reference materials???
I have several books, but the books do not cover some of the information I
need. I'd like to build a reference list (library), so I don't have to ask
so many simple questions...

Thank you,

Charles L. Phillips

Hello,
"Thank You".
I'll read this & apply/modify this process over the weekend...


Thank you,

Charles L. Phillips

Take a look at http://www.mvps.org/access/datetime/date0012.htm at "The
Access Web"

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Hello,
I developed a form in MS-Access 97 with the following fields:

1. Date Shipped Back To User (DateShippedBackToUser)

2. Follow UpDate (FollowUpDate)

3. Date Package Arrived (DatePackageArrived)

#1 sets the stage for #2 and #3.
I manually enter the date for #1
ALL packages are shipped overnight.

#2 is: Follow Up Date =DateAdd("d",3,[DateShippedBackToUser])

#3 is the same as #2, but I want the fnc to bypass weekend dates, and
put the following Monday date in the field.

Can someone point me in the right direction???


Thank you,

Charles L. Phillips

 

[Charles Phillips]

Hello,
"Thanks", I really needed some reference material...


Thank you,

Charles L. Phillips

The Access Web http://www.mvps.org/access/ is always a good place to start.

Also, take a look at what Jeff Conrad has at
http://home.bendbroadband.com/conradsystems/accessjunkie.html

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hello,
When you're a NEWBIE like myself, how do you know or where to look for
reference materials???
I have several books, but the books do not cover some of the information I
need. I'd like to build a reference list (library), so I don't have to ask
so many simple questions...

Thank you,

Charles L. Phillips

Hello,
"Thank You".
I'll read this & apply/modify this process over the weekend...


Thank you,

Charles L. Phillips


Take a look at http://www.mvps.org/access/datetime/date0012.htm at "The
Access Web"

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Hello,
I developed a form in MS-Access 97 with the following fields:

1. Date Shipped Back To User (DateShippedBackToUser)

2. Follow UpDate (FollowUpDate)

3. Date Package Arrived (DatePackageArrived)

#1 sets the stage for #2 and #3.
I manually enter the date for #1
ALL packages are shipped overnight.

#2 is: Follow Up Date =DateAdd("d",3,[DateShippedBackToUser])

#3 is the same as #2, but I want the fnc to bypass weekend dates, and
put the following Monday date in the field.

Can someone point me in the right direction???


Thank you,

Charles L. Phillips