Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a varialbe vSelectedDate, with the numeric equivalent of the 15.05.2014 (41773).
I have this input:
DATE_FROM | DATE_TO | VALUE |
---|---|---|
01.01.2000 | 31.12.2010 | 4.2 |
01.01.2011 | 30.09.2012 | 3.5 |
01.10.2012 | 31.12.2013 | 5.1 |
01.01.2014 | 30.09.2014 | 7.2 |
01.10.2014 | 31.12.9999 | 1.3 |
I'd like to output the value valid for the date in the vSelectedDate variable. My expression looks like the following:
concat({<[DATE_FROM]={"<=$($(vSelectedDate))"},[DATE_TO]={">=$($(vSelectedDate))"}>}DISTINCT VALUE)
My output should look like this: 7.2 (since the 15.05.2014 is greater than green and lesser than orange)
But my output looks like this: 1.37.25.13.54.2 (So it's the concatination of all values possible)
I looked into following threads, but I can't quite figure out why it won't work.
Using Greater Than in Set Analysis
Set Analysis - Dates greater than a given number of days ago
Try:
concat({<[DATE_FROM]={'<=$(=vSelectedDate)'},[DATE_TO]={'>=$(=vSelectedDate)'}>}DISTINCT VALUE)
if date format needed, then:
concat({<[DATE_FROM]={'<=$(=date(vSelectedDate'DD.MM.YYYY'))'},[DATE_TO]={'>=$(=date(vSelectedDate'DD.MM.YYYY'))'}>}DISTINCT VALUE)
May be this:
=Concat({<[DATE_FROM]={"<=$(=Date($(vSelectedDate), 'DD.MM.YYYY'))"}, [DATE_TO]={">=$(=Date($(vSelectedDate), 'DD.MM.YYYY'))"}>} DISTINCT VALUE)
Update: Sample attached
Try:
concat({<[DATE_FROM]={'<=$(=vSelectedDate)'},[DATE_TO]={'>=$(=vSelectedDate)'}>}DISTINCT VALUE)
if date format needed, then:
concat({<[DATE_FROM]={'<=$(=date(vSelectedDate'DD.MM.YYYY'))'},[DATE_TO]={'>=$(=date(vSelectedDate'DD.MM.YYYY'))'}>}DISTINCT VALUE)
Thank you!
Thank you very much!