Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Number of days between 2 days

Hello everyone,

I have a table with entries that have 2 datefields columns : Receipt Date and IssueDate (Issue is always after Receipt)

I have been using the following expression :

DayNumberOfYear(IssueDate) - DayNumberOfYear([Rct-Date))


and I get some negative values..

Is there a function that would return a positive value for (5-JAN-15) - (31-DEC-14) ?

For this instance Id like a function that would return =5

Is it possible ?

cheers,

alex

2 Replies
Gysbert_Wassenaar

Simply subtract the dates: interval(Date1 - Date2,'d')


talk is cheap, supply exceeds demand
ChiragPradhan
Creator II
Creator II

Use Floor function to convert the date to a number. Floor(Date(IssueDate) - Floor(Date(Rct-Date))

Regards

chirag