Date Expression

[Anonymous]

I have two date dimension--->Start_date and End_date.

Now, i want to create another date dimension which is greater than Start_date and less than End_date.

In that case , how can i write this date expression.

Please tell me exact expression for that.

[prma7799]

Please share some sample with Expected Output

[Anonymous]

if  i select this anonymous  date -' 06/17/2017'

then my output will be coming this type--->>>

start _date                 End_date

05/17 /2017             05/17/2018

i want this type of output.

[Anonymous]

if  i select this anonymous  date -' 06/17/2017'

then my output will be coming this type--->>>

Project_start _date                 Project_End_date

05/17 /2017                           05/17/2018

i want this type of output which fectch the data from this anonymous date.

[prma7799]

Like this?

Test:

LOAD * Inline [

Dates

17-06-2017

18-06-2017

19-06-2017

];

New:

LOAD Dates ,

Previous(Dates) as  StartDate ,

AddYears((Previous(Dates)),1) as EndDate

Resident Test;

[Anonymous]

But, i have huge amount of dates.I have already loaded the data as Start_date and End_date.

iN THAT CASE, I need proper expression for that.

[Anonymous]

Start_date and End_date , this two tables are already loaded.