Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Date(today(),'DD/MM/YYYY')-DocDate
Date(today(),'DD/MM/YYYY')-DocDate
Thanks
I don't think using Date() function is important here, just Today() - DocDate should also work
or if DocDate is loaded as text instead of a "real" (dual) date:
Date#(DocDate,'DD/MM/YYYY')-Today()
hope this helps
regards
Marco
Hi,
date((date(Today(),'DD/MM/YYY')-date(DocDate,'DD/MM/YYYY')),'DD')
please close this thread, if your question is answered:
Qlik Community Tip: Marking Replies as Correct or Helpful
thanks
regards
Marco