=DateAdd() Function

  • Thread starter Thread starter Charles Phillips
  • Start date Start date
C

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
 
Hello,
"Thank You".
I'll read this & apply/modify this process over the weekend...


Thank you,

Charles L. Phillips


Douglas J. Steele said:
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)


Charles Phillips said:
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
Click to expand...
Click to expand...
 
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


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


Thank you,

Charles L. Phillips


Douglas J. Steele said:
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)


Charles Phillips said:
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
Click to expand...
Click to expand...
Click to expand...
 
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)


Charles Phillips said:
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


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


Thank you,

Charles L. Phillips


Douglas J. Steele said:
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
Click to expand...
Click to expand...
Click to expand...
 
Hello,
"Thanks", I really needed some reference material...


Thank you,

Charles L. Phillips


Douglas J. Steele said:
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)


Charles Phillips said:
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


Charles Phillips said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top