Operations with dates

[#1]

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 · Accepted solution]

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

[#3]

Thanks

[sunny_talwar]

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

[MarcoWedel]

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]

Hi,

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

[MarcoWedel]

please close this thread, if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco