Retrieving data between two dates in report studio

[Kutti]

Hi all,

I have a requirement in my project to get the data from selected date in the prompt to financial year starting date.

I will be using Japanese financial year that is April-YY to March-YY (April 2010-March-2011). I have a Period prompt (List box) which will hold the date in Jan-10  format and if user selects Jan-10 then the data between April-09 to Jan-10 should be displayed.

I have created two data items. One data item to calculate the Financial year start date (April-YY) based on date selected from the period prompt and another data item to get the end date (which is same as date selected from the prompt).

Now my issue is i want to know the logic or syntax  to get the data between the dates using those two data items.

Please help me....

Thanks

[mrcool]

Hi,

You should have one date key in your fact joined with date dimension. Right?

If so you can give that date between Dataitem1(Financial year Start date) and dataitem2(Financial Year End Date).


Cheers,
Mrcool