Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
max200560
Contributor II
Contributor II

Difference between date

Hi Guy. I'm new of the community. I've a problem that I believe is easy to solve. I've two column (date of invoice and date of contract) and I need to calculate the days between the two date. I put a column with misures and search between the function one for my work but I don't find anything. Can you help me? Thank you.....

Labels (1)
1 Solution

Accepted Solutions
melissapluke
Partner - Creator
Partner - Creator

Great! Would you mind clicking "Accept Response" so this question isn't shown as "unanswered"?  Thanks! Good luck with your app!

Melissa

View solution in original post

3 Replies
melissapluke
Partner - Creator
Partner - Creator

Hello,

You should be able to just add a column with the two dates. For example, in my data I have an "Audit Completed Date" and a "Cases Completed Date". I added a new measure column which takes [Audit Completed date]-[Cases Completed Date] and it calculates the result.

melissapluke_0-1614963902904.png

 

max200560
Contributor II
Contributor II
Author

Thank you. I resolved with the expression 

Cattura.JPG

melissapluke
Partner - Creator
Partner - Creator

Great! Would you mind clicking "Accept Response" so this question isn't shown as "unanswered"?  Thanks! Good luck with your app!

Melissa