Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Please share some sample with Expected Output
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.
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.
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;
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.
Start_date and End_date , this two tables are already loaded.