- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Date Expression
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please share some sample with Expected Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Start_date and End_date , this two tables are already loaded.