if there is more than 1 day difference between start date and end date then need those detail as my output

[Srinivas]

Hi friends,

I have a requirement, that have some start date and end date 2 columns.

see the attached excel for reference...

if there is more than 1 day difference between start date and end date i need those dates in details as my output.

Thanks in Advance

Munna

[Kushal_Chawda]

Create straight table

Dimension:

StartDate

EndDate

Expression:

Count({<User={"=floor(EndDate)-floor(StartDate)>1"}>}User)

[avinashelite]

Try like this

T:

LOAD StartDate,

          EndDate,

          ID,

          User,

EndDate- StartDate as Flag

from

table;

Noconcatenate

T:

LOAD StartDate,

          EndDate,

          ID,

          User

from

table

where Flag>1;

Drop table T;

[Srinivas]

Hi,

sorry a bit confusion in typing,

if there is more than 1 date difference then i need those dates to be aloberated...see the excel

suppose start date is 1/1/2010 and end is 1/5/2010

the

i need 5 different dates like

1/1/2010 to 1/2/2010

1/2/2010 to 1/3/2010

1/3/2010 to 1/4/2010

1/4/2010 to 1/5/2010

Thanks,

Munna

[avinashelite]

you need to recreate the dates?? if that is the case use the master calendar and link you date

Creating A Master Calendar

[help4qv123]

How we can link...if we link it dates we can link min date to startdate and max date to end date...

but how can we get this type of output..can u help out if u got any idea