Common months between two years

Question

Hi,

I have requirement like my report is filtering data for 2 years (current year and previous year).

Using presentation variable to filter the report like this: @{year_pv} and @{year_pv-1}.

I need to further filter the report based on months.

for eg: my current year is 2016 and current month is for eg: Aug. then my report should filter data January to August for both the years (2015 and 2016).

2015 year is having all the months (Jan-Dec). How to filter my report based on this criteria?

Regards,

Ram.

Joel Acha · Answer

Then you can derive the month using MONTH(CURRENT_DATE) which will give you 12 for December.

So your filter will be where MONTH BETWEEN 1 AND MONTH(CURRENT_DATE)

Sent from my iPhone

User_JL3CW · Answer

HI,

The report runs on a day and month which it belong to. If my report runs today (31 Dec) then month belongs to December (Current Month). Current year it will take from (JAN-DEC) similarly for the previous year it should take (Jan-Dec).

regards,

ram.

Joel Acha · Answer

So in your previous example, where does August come from?

Sent from my iPhone