This content has been marked as final. Show 3 replies
I have an application that calculates the delays of payement. For example, in my script, I have :
let jj= left($(d),2);
let mm= mid($(d),4,2);
and then I create new variables in the script like :
makedate($(aa), $(mm), $(jj)) - [Date_mvt] as delay
and other one depending on today value.
Now, I would like to run the Qlikview with on another date as "today". I have tried to replace
let d=today() - 200 ;
(to be 200 days earlier) but I get the oracle error : literal does not match format string.
How can I do to "change" today()'s value ?
Thanks for your help