Previous Year to Previous Year Date

[TEM3]

({ALL_ASSIGNMENTS.Date Assigned} in date(year(currentdate),01, 01) to currentdate)

The above works fine for the current year's numbers. Now I want to run the same report for the previous year. How do I need to change the selection formula??

 

[lbass]

{ALL_ASSIGNMENTS.Date Assigned} in date(year(currentdate)-1,01, 01) to date(year(currentdate)-1,month(currentdate),day(currentdate))

-LB

 

[bdreed35]

You can also use the built in functions YearToDate and LastYearYTD:

This year:

{ALL_ASSIGNMENTS.Date Assigned} in YearToDate


Last Year:

{ALL_ASSIGNMENTS.Date Assigned} in LastYearYTD

~Brian

 

[TEM3]

Thank you to both of you.

I keep being alerted to date functions in Crystal Reports that I had no idea of their existance.

Where can I find a list of data function available in CR 8.5. (I'd look in help, but after a couple install tries I still have not been able to get the Help files to install!).

 

[dgillz]

The help files not being available is a known issue. Here is the fix for it:

http://support.businessobjects.com/library/kbase/articles/c2010291.asp

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com