I need to create a label for a mont

[JM3482]

I need to create a label for a monthly date range in a report, but I am not using any date parameters or date formulas. I checked out special fields area and did not find anything workable. I would need to show the previous month date from and date to (10/1/2003 - 10/31/2003). I do have fields like "eff_start_date" and "eff_end_date" but am not using that field in any formulas or parameters.

 

[pgtek]

Hi
try using currentdate - 30

cheers

pg

pgtek

 

[rhinok]

Create a formula called @LastMonthRange and use the following:

Minimum(LastFullMonth) + " - " + Maximum(LastFullMonth)

 

[lbass]

rhinok's formula will work if you change the "+"s to "&"s:

Minimum(LastFullMonth) & " - " & Maximum(LastFullMonth)

-LB

 

[rhinok]

Sorry, I posted too quickly. You're right.