Does "LastFullMonth" work for January

[kate8]

Hi,

I am using LastFullMonth for reports which are scheduled run in Crystal Enterprise. The reports are automatically run every month and pull out of data for last month. My question is that if the month falls into January, for example 01/01/2012, can LastFullMonth select the data from 12/2011? Or I need to do the conversion in the report?
Thank you for any helps!!!!

 

[fisheromacse]

lastfullmonth should do what you request.

 

[kate8]

fisheromacse,

Thank you so much!! You meant I don't need add anything?!
I have over hundred reports and I can't change my system time to test.

 

[fisheromacse]

you are using this as selection criteria, right?

the statement in the Select Expert would look like this:
{Table.DateField} in LastFullMonth

 

[kate8]

Yes,that is how my reports use it.
One of my colleague thinks I should do the conversion, I want to make sure if the lastfullmonth can take care of it itself.

 

[lbass]

I agree with fisheromacse. It will work.

-LB

 

[fisheromacse]

wooo hooo!!

ego boost!

lbass agreed w/me!

all those previous copy/paste of her posts to answer new questions have finally paid off, a little bit of crystal knowledge has sunk into my skull AND (wonder of wonders!) has been recalled accurately! <grin>

 

[kray4660]

I thought I was halfway decent with CR until I got to this post and watched as lbass put me to shame.