Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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