Date Variable

QlikBeginner1 — Wed, 05 May 2021 15:08:24 GMT

Hello,

LET vReloadDate = Date(ReloadTime(),'DD/MM/YYYY');

I have this variable stored in my app.

I have a number of flags for a report I am building, and I am trying to use the Date(ReloadTime(),'DD/MM/YYYY') as a variable in my load editor, but the results differentiate to when I use a hardcoaded Date(ReloadTime(),'DD/MM/YYYY'). Please see examples below,

IF(Date(ZMEffectiveDate,'DD/MM/YYYY') > '$(vReloadDate)' ,0,1) as ZMBBNIVAL01, - This is what I tried when using the variable above.

IF(Date(ZMEffectiveDate,'DD/MM/YYYY') > Date(ReloadTime(),'DD/MM/YYYY'),0,1) as ZMBBNIVAL01, - This is when I hardcoded the Reload time instead of using the variable. The results shown from this is correct.

The reason why I am trying to use as a variable, is because I want to add functionality where the user is able to amend the date which will change the results of the report if they would like to see past history.

Any understanding into why the variable is not working correctly?

Thanks in advance,

Re: Date Variable

JuanGerardo — Wed, 05 May 2021 17:23:48 GMT

Hi @QlikBeginner1 , have you tried initializing your variable with SET instead of LET?

And in case of LET, you can try:

IF(Date(ZMEffectiveDate,'DD/MM/YYYY') > '$(=vReloadDate)' ,0,1) as ZMBBNIVAL01

Please, pay attention to the equal sign.

topic Date Variable in App Development

Date Variable

Re: Date Variable