Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Fanch
Partner - Creator
Partner - Creator

Variable Date on URL API Rest Connection

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, ☹️

Vrops.JPG

Does anyone have an idea ???? 🙄

 

 

1 Solution

Accepted Solutions
Anil_Babu_Samineni

Since you are saying 8th  december it is working could be souce having issue with the format of 9th Dec - Check once?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

2 Replies
Anil_Babu_Samineni

Since you are saying 8th  december it is working could be souce having issue with the format of 9th Dec - Check once?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Fanch
Partner - Creator
Partner - Creator
Author

Thanks for our answer Anil 😉

But, it's just ..... a programming default that i resolved myself 🙄 🙄 🙄

Sorry for the inconvenience