Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have following
You 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
You don't seem to have much of a following.
Do you at least have a question you want help with?
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
You 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