Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
i'm building a Qlickview document with API Rest Connection. On the URL, i need to have two variables begindata et enddata to have the data. I initialized the variable like this 🙂 :
// Variables bornes(ms) dans lien vrops
Let bornevrops=Date('01/01/1970 00:00:01');
Let bornebegin=Date('15/10/2020 00:00:01');
Let borneend=Date(Now(),'DD/MM/YYYY');
Let bornevropsms=Num(Date('01/01/1970 00:00:01')) * 86400000;
Let bornebeginms=Num(Date('15/10/2020 00:00:01')) * 86400000;
Let borneendms=Num(Date(Now()))* 86400000;
Let begindata=Num($(bornebeginms) - $(bornevropsms));
Let enddata=Num($(borneendms) - $(bornevropsms));
I continued to initialize the URL like this 🙂 :
$(begindata)&end%2$(enddata)&intervalType%2DAYS
At the date of 9th, december, it was ok. 😀
But today, when i reload the Qlikview document, my data stop at the 9th, december, ☹️
Does anyone have an idea ???? 🙄
Since you are saying 8th december it is working could be souce having issue with the format of 9th Dec - Check once?
Since you are saying 8th december it is working could be souce having issue with the format of 9th Dec - Check once?
Thanks for our answer Anil 😉
But, it's just ..... a programming default that i resolved myself 🙄 🙄 🙄
Sorry for the inconvenience