Month Formula

A

Aurora

I am using Access 2000
I have created a report that will be run monthly. I would like to add a
date formula in the heading that will give a monthly date (Ex: May, 2005)
for the next month. In order words, I am running the report today (June 21,
2005) but want the date in the heading to read - July, 2005.

How can I do this?

Aurora
 
J

Jeff Boyce

Aurora

You can get today's date with the Date() function.

You can get "next month" by adding one month to today (see DateAdd()
function).

You can get "July - 2005" by formatting "next month" (see Format()).

Good luck

Jeff Boyce
<Access MVP>
 
A

Aurora

Jeff:

I was unable to make your suggestions work.
I tried - =DateAdd("d",15,Date()) But I got July 21, 2005 instead.
I tried - =DateAdd("m",15,Date()) This did not work either. I get a time
in the future - 2006.
I looked in Help for "format() - but couldn't find anything there that I
thought would work.
Can you point me in another direction. I want to take this month and add
one month to it and only get the "month & year" only or Month 1, Year (July
1, 2005). The report is as of the first of the month.
 
D

Duane Hookom

Jeff suggested you add a month to today while you tried adding 15 days and
then 15 months. Where did "15" come from?

I know Jeff and many others could provide the answer more quickly than
helping you find the answer. Come on back if you can find the answer.
 
A

Aurora

Thank you Jeff - I finally got it to work.
I just needed to format the field to month and year.
Aurora
 
A

Aurora

Thank you for responding. I figured it out.
I just had to format the filed to show month and year.
I have it working now - at least I think I do. We will see
what happens next month.
But thank you again for responding.
Aurora
 
E

ETC

I'm trying to do the exact same thing you are. How did you format it to read
"Month Year". I'm trying to do it in the Report Header and it's not working
for me.
 
Top