Month Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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>
 
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.
 
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.
 
Thank you Jeff - I finally got it to work.
I just needed to format the field to month and year.
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
 
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.
 
Back
Top