topic Re: Days Calculation in QlikView

Days Calculation

mario-sarkis — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I need to calculate the difference between 2 dates in the script below what I have a fields:

Assessment Date Submitted Date

6/30/2017 7/28/2017

the output field should be 21 Days "6/30/2017 - 7/28/2017 = 28 Days"

hope you can help thank you

Frank_Hartmann — Thu, 13 Jul 2017 11:11:53 GMT

Date(Date#([Submitted Date],'MM/DD/YYYY'),'MM/DD/YYYY')-Date(Date#([Assessment Date],'MM/DD/YYYY'),'MM/DD/YYYY') as Days

hope this helps

sunny_talwar — Thu, 13 Jul 2017 11:46:00 GMT

If your date fields are read as dates by qlikview, all you need is to do this

[Submitted Date] - [Assessment Date]

For help with reading dates correctly, read these guys

arvind_patil — Thu, 13 Jul 2017 11:54:58 GMT

Hi Mario,

Maybe it will help you:

Num(Date(Date#([Submitted Date],'MM/DD/YYYY'),'MM/DD/YYYY'))-num(Date(Date#([Assessment Date],'MM/DD/YYYY'),'MM/DD/YYYY')) as Days

Thanks,

Arvind Patil