Display last month's date value in report header

[rhammond]

I'm trying to display in the header of my report the value for last month (in the following format - "December 2002&quot. How can I do this, especially since I'm not actually reading this value from a particular database value?

 

[synapsevampire]

Create a formula which contains:

dateadd('m',-1,currentdate)

Now right click it and select format field.

Select Customize and under the Format Select the text for the month, None for the day, and 1999 for the year.

Under Seperators place a space.

If it's a datetime field, set all of the time options to None, and the AM/PM to blank


-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[rhammond]

That was it! I knew it had to be something simple like that, but sometimes staring at all the formulas makes you a bit blind...