Date Variable

[upaliwije]

Hi,

I have created a date variable in QV app

vP16={'>={15-AUG-2016} <={01-SEP-2016'}

How ever this return 0 vale when applied in following expression

sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DATE=$(vP16)>}Nos)

Pls advise where I have made the mistake

[Kushal_Chawda]

why don't you directly write in set analysis instead of creating variable

sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DATE={'>=15-AUG-2016 <=01-SEP-2016'}>}Nos)

or

vP16='>=15-AUG-2016 <=01-SEP-2016'

sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DATE={'$(vP16)'}>}Nos)

[upaliwije]

Thanks Kushal

In fact I have several expression in doc so it is easy for me to use a variable. However your expression works but not when the expression with variable is applied. I feel something wrong with the definition of variable. Pls advise.

[Kushal_Chawda · Accepted solution]

vP16='>=15-AUG-2016 <=01-SEP-2016'

sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DATE={$(vP16)}>}Nos)

there will be error but it will work

[upaliwije]

Thanks a lot

[arasaraja_cts]

Hi,

PFA, hope it will help.

Thanks

Raja.