Expression for orders where completed date after order date

[rcorcoran]

Hi

I am new to Qlikview and I am trying to write an expression for a chart that will count  the Order ID
where the 'completed date' is 5 days after the 'order date'.  The completed date and order date have timestamps also.

Thanks

[#2]

Can you post a sample app?

[rcorcoran]

  I really haven't a clue I was trying something like this:

count({$<[completed_date] = {$(=(order_date) + 5)}>} order_id)

But the date format for both the order date and completed_date is dd/mm/yy 00:00:00

[Nicole-Smith]

Try this (if it doesn't work, please post a sample app):

count({$<[completed_date] = {$(=date((order_date) + 5, 'DD/MM/YY hh:mm:ss'))}>} order_id)

[Nicole-Smith]

Also check that QV recognizes completed_date and order_date as dates/numbers (put each in a list box and make sure they are right aligned).