I have this report which is a Monthly report and returns data  for the previous Month. Now the requirement is that we need to replicate the report so that it returns Data on a Daily purpose inclusive from the first Day of the month to the previous Day. Can anyone throw some light on this by providing the formula which i can use it in the Record Selection Formulas.

 

 

Thanks

Month ({RECOVERY.RECOVERY_DATE}) = {@ReportMonth} and
Year ({RECOVERY.RECOVERY_DATE}) = {@ReportYear}

 

where @ReportMonth has a formula under it which returns data for previous month.

{@ReportMonth=If Month(CurrentDate) = 1 then
    12
else
Month(CurrentDate)-1

and {@ReportYear} =if Month(CurrentDate)= 1 and Day(CurrentDate) = 1 then
    Year(CurrentDate) - 1
else
    Year(CurrentDate)

 

 

 

I havent tried ur Formula but it looks ok except the 'keep and no keep' part.

 my requirement is to get the Current month  data for each and every Date from the 1st of the current month  upTo Yesterday but not inclusive of Todays Data.

 

 

Thanks man