topic Re: Can we calculate difference between two date variables in QlikView

Can we calculate difference between two date variables

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

I am having two date variables V_Startdate and V_Enddate need to calculate Difference between the two date in expression, can any one help me.

=V_End_Date - V_Start_Date

Re: Can we calculate difference between two date variables

pathiqvd — Thu, 05 Jan 2017 04:59:08 GMT

Hi,

What do you expecting, If You want calculate between days use interval# or Hours/Mins use interval function

like:-

Interval(V_End_Date - V_Start_Date,'mm')

Interval(V_End_Date - V_Start_Date,'HH')

Interval(V_End_Date - V_Start_Date,'hh:mm:ss')

Interval#(V_End_Date - V_Start_Date,'DD')

Regards,

Re: Can we calculate difference between two date variables

Anonymous — Thu, 05 Jan 2017 06:25:46 GMT

Hi,

Please find the attached screen shots. in want to calculate No of days between 01-Jul-2015 to 31-Dec-2015. but no output was showing.

Expression:

Variables

Output

Re: Can we calculate difference between two date variables

pathiqvd — Thu, 05 Jan 2017 06:34:59 GMT

Hi,

May be your dates are not in date format.Please convert to date format using date#, Then check it will work

date(date#(v_start_date,'DD-MMM-YYYY'),'DD-MM-YYYY')

date(date#(v_end_date,'DD-MMM-YYYY'),'DD-MM-YYYY')

Regards,

Re: Can we calculate difference between two date variables

Anonymous — Thu, 05 Jan 2017 06:48:22 GMT

Changed Even also there was no Result.

=Interval#(Date(V_End_Date,'DD-MMM-YYYY')-Date#(V_Start_Date,'DD-MMM-YYYY'),'DD')

Re: Can we calculate difference between two date variables

Anil_Babu_Samineni — Thu, 05 Jan 2017 06:51:32 GMT

Can you send the Application

Re: Can we calculate difference between two date variables

Anonymous — Thu, 05 Jan 2017 07:06:34 GMT

Please find the attached QVD.

Re: Can we calculate difference between two date variables

pathiqvd — Thu, 05 Jan 2017 07:07:15 GMT

Hi,

Can you send data or application?

Re: Can we calculate difference between two date variables

Anonymous — Thu, 05 Jan 2017 07:09:37 GMT

Dear Lakshmipathi,

Please find the Qvw.

Re: Can we calculate difference between two date variables

Thu, 05 Jan 2017 07:09:41 GMT

Hi,

Try to convert the variables into proper date format and then use interval.

Attaching my application for reference.

Hope it helps.

Regards,

Navya

Re: Can we calculate difference between two date variables

pathiqvd — Thu, 05 Jan 2017 07:20:44 GMT

Hi,

Please find below image, Change date format in variable overview you will get

Re: Can we calculate difference between two date variables

Thu, 05 Jan 2017 07:40:37 GMT

Hi Rafeee,

create variables like

date1 =date#('03_Mar_2015','DD_MMM_YYYY')

date2 =date#('31_Dec_2015','DD_MMM_YYYY')

=date2-date1 returm 303

Re: Can we calculate difference between two date variables

surendraj — Thu, 05 Jan 2017 07:55:53 GMT

Hi Rafeee,

I tried this,its working for me.the difference between the dates are 183 days.

(or)

try with interval function,

=interval(date(date#(vend_date,'DD-MMM-YYYY'),'DD-MM-YYYY')-date(date#(vstart_date,'DD-MMM-YYYY'),'DD-MM-YYYY'),'DD')

--surendra