topic Re: How to count ageing? Date differences. in QlikView

How to count ageing? Date differences.

Mon, 13 Aug 2012 06:07:19 GMT

Hi,

How to get ageing, say for example, due date is 8/1/2012 and today is 8/13/2012, expected ageing should be 12 days or 13 days, not sure with it.. how to get differences.... say TODAY minus DUE DATE?

need help, thanks.

Re: How to count ageing? Date differences.

Sokkorn — Mon, 13 Aug 2012 06:26:12 GMT

Hi,

It simple to get this job done. Just use EndDate - StartDate. Ex. =Today() - DATE('01-08-2012') ==> Returen 12.

Or use Networkdays(start:date, end_date {, holiday}) ==> Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

Regards,

Sokkorn

Re: How to count ageing? Date differences.

Mon, 13 Aug 2012 06:37:42 GMT

You can also try using AGE to get the required result!

Re: How to count ageing? Date differences.

Mon, 13 Aug 2012 06:40:33 GMT

thanks.

Re: How to count ageing? Date differences.

kalyandg — Tue, 16 Oct 2012 04:40:46 GMT

i used EndDate-StartDate, we get answer as substraction, (eg) StartDate=08/01/2012 and EndDate=08/15/2012, if we calculate as per your answer it substracts 15-1=14, but it is not right, it should be 15 days. Please help me to solve this problem