Days Calculation

[mario-sarkis]

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]

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]

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

Why don’t my dates work?

QlikView Date fields

Get the Dates Right

[arvind_patil]

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