topic Re: difference of two dates in variable in QlikView

difference of two dates in variable

viveksingh — Sat, 16 Nov 2024 19:01:35 GMT

Hi All,

I have two date fields in two different variable. I want to calculate the dates difference in days. I used Interval(). but still no luck. below is my code

let vInput1con= peek('Input1',0,'CONF1'); //Input1= 20191210
let vInput2con= peek('Input2',0,'CONF1'); //Input2= 20200101
let vMinDate=Date(Date#('$(vInput1con)','YYYYMMDD'),'YYYYMMDD');
let vMaxDate=Date(Date#('$(vInput2con)','YYYYMMDD'),'YYYYMMDD');

Let vdays=Interval($(vMaxDate)- $(vMinDate),'D');

Please help o=in finding the no. of days.

Re: difference of two dates in variable

Taoufiq_Zarra — Fri, 28 Feb 2020 09:11:51 GMT

may be :

let vInput1con= peek('Input1',0,'CONF1'); //Input1= 20191210 let vInput2con= peek('Input2',0,'CONF1'); //Input2= 20200101 let vMinDate=Date(Date#('$(vInput1con)','YYYYMMDD'),'DD/MM/YYYY'); let vMaxDate=Date(Date#('$(vInput2con)','YYYYMMDD'),'DD/MM/YYYY'); Let vdays=Interval('$(vMaxDate)'- '$(vMinDate)','D');

Re: difference of two dates in variable

Brett_Bleess — Wed, 01 Apr 2020 14:31:00 GMT

Vivek, did Taoufiq's post get you a working solution? If so, please be sure to close out your thread by returning to it and on his post, use the Accept as Solution button to mark it which will give him credit for the help and let other Members know that worked. If you did something different, please consider posting that and then mark it using the button after you post. If you have further questions, please leave an update post. It is appreciated if you close out your posts if possible.

Regards,
Brett