Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

problem calculating difference between 2 dates

Hi

I am trying out Qlikview. I have made a connection to different sql tables and now I am trying to calculate the payment terms on invoices by substracting two dates from each other and saving them as a new field. Calculation works fine, but ... is always wrong by 2 days. When payment term is 14 days, is calculates 16 days. What is going wrong ? Any ideas ?

TXS

1 Reply
swuehl
MVP
MVP

Could you give an example of raw data field values, your Script expression and your expected outcome ?