topic Re: How to get the days difference in QlikView

How to get the days difference

Fri, 13 Sep 2013 07:45:07 GMT

Hi All,

Is there any function in QV like SQL function:datediff(day, startdate , enddate) ?

Thanks.

Re: How to get the days difference

tresB — Fri, 13 Sep 2013 07:47:04 GMT

Interval() ?

Like: Interval(startdate-enddate, 'DD') // or changing the order of dates

Re: How to get the days difference

Sokkorn — Fri, 13 Sep 2013 07:48:56 GMT

Hi Isaac,

Try to use Interval(EndDate-StartDate,'D') or simply use EndDate-StartDate to get day different.

Regards,

Sokkorn

Re: How to get the days difference

Fri, 13 Sep 2013 08:10:36 GMT

You can also sort it asc in a straight table and do an Above expression.

Example:

(Date)-(Above(Date))

Thanks

Stefan

Re: How to get the days difference

techvarun — Fri, 13 Sep 2013 09:44:49 GMT

1. date((date(Field1,'MM/DD/YYY')-date(Field2,'MM/DD/YYYY')),'DD')

2. Interval(Field1-Field2,'dd')

3.date(timestamp#(Field1,'MM/DD/YYYY hh:mm:ss'),'DD/MM/YYYY') as Date2,

date(timestamp#(Field1,'MM/DD/YYYY hh:mm:ss'),'DD/MM/YYYY') as Date1,

Interval( (date(timestamp#(date2,'MM/DD/YYYY hh:mm:ss'),'DD/MM/YYYY')) - (date(timestamp# (date1,'MM/DD/YYYY hh:mm:ss'),'DD/MM/YYYY')), 'd') as DTDiff

Use this thread

regards