Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Operations with dates

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

1 Solution

Accepted Solutions
aarkay29
Specialist
Specialist

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

View solution in original post

6 Replies
aarkay29
Specialist
Specialist

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

Not applicable
Author

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
Partner - Creator III
Partner - Creator III

Hi,

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

Muthukumar Pandiyan
MarcoWedel

please close this thread, if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco