How to use greater than with variables and two (or more) modifiers?

[#1]

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

Set analysis greater than less than

[sunny_talwar]

May be this:

=Concat({<[DATE_FROM]={"<=$(=Date($(vSelectedDate), 'DD.MM.YYYY'))"}, [DATE_TO]={">=$(=Date($(vSelectedDate), 'DD.MM.YYYY'))"}>} DISTINCT VALUE)

Update: Sample attached

[Qrishna · Accepted solution]

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)

[#4]

Thank you!

[#5]

Thank you very much!