Date Format and DateAdd

  • Thread starter Thread starter Bonnie A
  • Start date Start date
B

Bonnie A

Hi everyone! Using A02 on XP. I have a letter and in one paragraph I have a
date that is calculated to be 14 days after the date of the letter. The date
of the letter is answered by a parameter inquiry [What date for letter, leave
blank for today]. So in the letter I have this:

...was sent to you on " & DateAdd("d",14,[DateRequested]) &". Please
check...

which prints this:

....was sent to you on 02/16/2009. Please check...

And I want this:

....was sent to you on February 16, 2009. Please check...

I've got this in another area:

on " & Format([Data Req],"mmmm dd"", ""yyyy") & ".

And it prints 'February 16, 2009' like I want it.

How can I combine the two so my first item prints AND calculates 14 days?

Thanks in advance for any assistance or advice!
 
Thank you so much!!! I didn't remove the double quotes. They are my bane!

I really appreciate how quickly you got to it!!!

--
Bonnie W. Anderson
Cincinnati, OH


Douglas J. Steele said:
Format(DateAdd("d",14,[DateRequested]), "mmmm dd, yyyy")

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Bonnie A said:
Hi everyone! Using A02 on XP. I have a letter and in one paragraph I
have a
date that is calculated to be 14 days after the date of the letter. The
date
of the letter is answered by a parameter inquiry [What date for letter,
leave
blank for today]. So in the letter I have this:

...was sent to you on " & DateAdd("d",14,[DateRequested]) &". Please
check...

which prints this:

...was sent to you on 02/16/2009. Please check...

And I want this:

...was sent to you on February 16, 2009. Please check...

I've got this in another area:

on " & Format([Data Req],"mmmm dd"", ""yyyy") & ".

And it prints 'February 16, 2009' like I want it.

How can I combine the two so my first item prints AND calculates 14 days?

Thanks in advance for any assistance or advice!
Click to expand...
Click to expand...
 
Thank you so much!!! I didn't remove the double quotes. They are my bane!

I really appreciate how quickly you got to it!!!

--
Bonnie W. Anderson
Cincinnati, OH


Douglas J. Steele said:
Format(DateAdd("d",14,[DateRequested]), "mmmm dd, yyyy")

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Bonnie A said:
Hi everyone! Using A02 on XP. I have a letter and in one paragraph I
have a
date that is calculated to be 14 days after the date of the letter. The
date
of the letter is answered by a parameter inquiry [What date for letter,
leave
blank for today]. So in the letter I have this:

...was sent to you on " & DateAdd("d",14,[DateRequested]) &". Please
check...

which prints this:

...was sent to you on 02/16/2009. Please check...

And I want this:

...was sent to you on February 16, 2009. Please check...

I've got this in another area:

on " & Format([Data Req],"mmmm dd"", ""yyyy") & ".

And it prints 'February 16, 2009' like I want it.

How can I combine the two so my first item prints AND calculates 14 days?

Thanks in advance for any assistance or advice!
Click to expand...
Click to expand...
 
Back
Top