Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 upaliwije
		
			upaliwije
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I have following
 Gysbert_Wassena
		
			Gysbert_WassenaYou create your VFROM as a text string value and then use the >= comparison operator to compare that with a date value. I think that's your problem. If you create VFROM as a date value it'll probably work
Date(POL_PERIOD_FROM,'MMM-YYYY')AS VFROM
 Gysbert_Wassena
		
			Gysbert_WassenaYou don't seem to have much of a following. 
Do you at least have a question you want help with?
 
					
				
		
 upaliwije
		
			upaliwije
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Very Sorry I accidentally posted halfway through the writing. This is my issue
I have following set expression which does not return a value
sum({<VFROM={">=$(v1)"}>}PREMIUM)
VFROM=DEC-2017 ( a field created while loading data) Month(POL_PERIOD_FROM)&'-'&Year(POL_PERIOD_FROM)AS VFROM
v1= =DEC-2017 a vraiable (Let v1=Date(Makedate(2017,12,01),'MMM-YYYY'))
I seek your help to get my expression corrected
 Gysbert_Wassena
		
			Gysbert_WassenaYou create your VFROM as a text string value and then use the >= comparison operator to compare that with a date value. I think that's your problem. If you create VFROM as a date value it'll probably work
Date(POL_PERIOD_FROM,'MMM-YYYY')AS VFROM
