Record Select on Last Year Last Full Month 1

[dleewms]

I'm using Crystal XI. I need to filter my records and get only last year's records up to the last day of the last full month. There is a handy lastfullmonth function I can use if I wanted records up to June 30, 2011. I need to filter them for records with an invoice date between January 1, 2010 and LAST YEAR'S last full month (i.e. June 30, 2010).

In the select records formula editor I've started to create the formula as:

{sr.invoice_date} in LastYearYTD or sr.invoice_date in ____________ (need syntax to get Last Year Full Month.

Thanks!

 

[lbass]

dateserial(year(currentdate)-1,1,1) to
dateserial(year(currentdate)-1,month(currentdate),1)-1

-LB

 

[dleewms]

That did it LBass.

Thanks a lot!