Crystal Reports 11, lastfullmonth, Oracle 10g, BOXIR2

[hsandwick]

Is it possible to capture data for 2 months ago using "lastfullmonth" in the record selection criteria?

I.e., lastfullmonth -1 is what I am trying to achieve.

Thank you,
Helen

 

[jdemmi]

minimum(lastfullmonth) -1

-- Jason
"It's Just Ones and Zeros

 

[jdemmi]

oops...that's only subtracting 1 day...

try this

dateadd("m", -1, minimum(lastfullmonth))

-- Jason
"It's Just Ones and Zeros

 

[bdreed35]

Your criteria should look something like this for the month before the last full month:

{table.date} in dateadd("m", -1, minimum(lastfullmonth)) to_ minimum(lastfullmonth)

The underscore is there by design.

~Brian

 

[hsandwick]

jdemmi and bdreed35:

Wonderful! Thanks so much for your help.

Regards,
Helen