topic Re: Operations with dates in QlikView

Operations with dates

Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone.

I need your help to get Number of days between today and "DocDate" field that has format= dd/mm/yyyy.

Please could you help me?

Thanks

Nancy

aarkay29 — Wed, 22 Feb 2017 20:06:31 GMT

Date(today(),'DD/MM/YYYY')-DocDate

Wed, 22 Feb 2017 20:08:33 GMT

Thanks

sunny_talwar — Wed, 22 Feb 2017 20:36:56 GMT

I don't think using Date() function is important here, just Today() - DocDate should also work

MarcoWedel — Wed, 22 Feb 2017 22:58:31 GMT

or if DocDate is loaded as text instead of a "real" (dual) date:

Date#(DocDate,'DD/MM/YYYY')-Today()

hope this helps

regards

Marco

muthukumar77 — Thu, 23 Feb 2017 05:54:25 GMT

Hi,

date((date(Today(),'DD/MM/YYY')-date(DocDate,'DD/MM/YYYY')),'DD')

MarcoWedel — Mon, 27 Feb 2017 22:53:38 GMT

please close this thread, if your question is answered:

thanks

regards

Marco