Date Range

[#1]

Hi

I have two dimensions in my report (pivot or straight) displaying start date & end date. Now i want to display all the dates between start date & end date.

[RedSky001]

You'll need to create a Calendar and use the intevalmatch function (see below for an example)

Calendar: 

LOAD

Date('01/01/2011' + RowNo() - 1) AS Date 

AUTOGENERATE 3000;

Transactions:

load * Inline [StartDate,EndDate

01/01/2012,01/06/2012

];

Inner Join IntervalMatch (Date) LOAD

StartDate, EndDate

RESIDENT Transactions;

[#3]

Xooooooooooooow, Tanks msheraton

[RedSky001]

Please can you mark my post as correct, thanks