Printing multiple historical dates

[sgd3476]

I would like to show previous monthly market value balances. My report calls for an "As of" date. I would like to show all month end market values for a year prior to my "As Of" date. Is there a date formula that can do this? My database only keeps data for business days not all calendar dates.

Example. as of= 01/15/2003
output==

12/31/02 = 1,004,001
11/29/02 = 1,001,000

Thanks

 

[putts]

You could "Format Section" for each record detail and put this in the Suppress formula:

if month({DBDateField}) < month(DateAdd(&quot;d&quot;,1,{DBDateField})) then
true
else
false

 

[putts]

Typo:

Switch the true and false

:]