Year To Date formula issue

[jyoti05]

I am using Crystal Reports 10. I am having a chart that displays data for 2 years in a bar chart. I want to pick the system date and retrieve data UPTO the current year and upto the same period last year.

For e.g today the date range would be
{MCTCase.Case_Close_Date} in 1/1/2005 - 4/26/2005 and
{MCTCase.Case_Close_Date} in 1/1/2006 - 2/26/2006.

I saw the LastYearYTD and YearToDate functions. How do i use that for same field in record selection. I want to automate and schedule..

e.g.
{MCTCase.Case_Close_Date} in YearToDate and
{MCTCase.Case_Status_Code} = "C"

Thanks!

 

[jyoti05]

I managed to resolve it!

{MCTCase.Case_Close_Date} in YearToDate or
{MCTCase.Case_Close_Date} in LastYearYTD and
{MCTCase.Case_Status_Code} = "C

 

[kskid]

Change it slightly

(
{MCTCase.Case_Close_Date} in YearToDate or
{MCTCase.Case_Close_Date} in LastYearYTD
) and
{MCTCase.Case_Status_Code} = "C

 

[jyoti05]

Thanks! I did that... It would be inefficient not to do so without brackets...