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
 
					
				
		
 Qrishna
		
			Qrishna
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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)
 sunny_talwar
		
			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
		
			Qrishna
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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!
