topic How to get the difference between two dates like YY-MM-DD? in QlikView

How to get the difference between two dates like YY-MM-DD?

Sun, 11 Jan 2015 04:19:05 GMT

Hi Qlikheads

can any one help me ,How to get the difference between two dates like YY-MM-DD?

Thanks

John

Re: How to get the difference between two dates like YY-MM-DD?

Anonymous — Sun, 11 Jan 2015 05:15:00 GMT

Hi,

Use like Date(Date#('Today()','YY-MM-DD') - Date#('14-12-12','YY-MM-DD') , 'MM/DD/YYYY')

For more info check the blog mentioned below

The Date Function

Thanks,

Vignesh

Re: How to get the difference between two dates like YY-MM-DD?

Sun, 11 Jan 2015 05:53:35 GMT

you can use the internal function Age(param1,param2) where param1 and param2 are your two dates. It returns the difference in number of days. There is also a macro that can return years, months, days of difference.

Re: How to get the difference between two dates like YY-MM-DD?

Sun, 11 Jan 2015 06:13:46 GMT

sorry is in years not days.

ie:

age('2007-10-29', '2005-10-29') returns 2

you can also check these threads:

Difference between two dates in Year,Month and ... | Qlik Community

Re: How to get the difference between two dates like YY-MM-DD?

SunilChauhan — Sun, 11 Jan 2015 06:23:15 GMT

if both are in same format then

you could use

date1-date2 as diffrence

other wise

DATE(date1,'YY-MM-DD') - DATE(date2,'YY-MM-DD') AS DIFFERENCE

interval(Date1-Date2,'DD')

age(Date1,date2)

DATE(date#(date1),'YY-MM-DD') - DATE(Date#(date2),'YY-MM-DD') AS DIFFERENCE

hope this helps