Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Suppose i have one date like '01-06-2001' and another date is '01-06-2015' I want to find that years between to date in qlikview.
How to achieve that.
Thanks
Hi Jagan,
you solution is write I tried with below
=fabs(Age(Date#('01-06-2001','DD-MM-YYYY'),Date#('01-06-2015','DD-MM-YYYY')))
=Year(Date#('01-06-2015','MM-DD-YYYY')) - Year(Date#('01-06-2011','MM-DD-YYYY') )
Hi anbu,
I want year count.
eg. Suppose i bought one car on 01-06-2011 and still i am using that car so i want to know i many years i used that car.
Thanks
Try age() for finding number of years, or interval() for more details - xx years xx months xx days
=Age(today(), '01-06-2011 ') -- gives 3 (i.e. 3 years)
Hi Tresesco,
I tried but output is not coming.
Hi,
Try like this
=Age(Date1, Date2)
OR Ceil(Interval(Date1 - Date2)/365)
OR Ceil((Date1 - Date2)/365)
In place of Ceil() you can also try Round() .
Regards,
Jagan.
That could beacuse of improper date format. check your default date format in the app and try with that. Else can try like this too:
Age(today(), Date#('01-06-2011 ', 'DD-MM-YYYY'))
Hi Jagan,
you solution is write I tried with below
=fabs(Age(Date#('01-06-2001','DD-MM-YYYY'),Date#('01-06-2015','DD-MM-YYYY')))