how to find years

[Anonymous]

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

[anbu1984]

=Year(Date#('01-06-2015','MM-DD-YYYY')) - Year(Date#('01-06-2011','MM-DD-YYYY') )

[Anonymous]

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

[tresesco]

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)

[Anonymous]

Hi Tresesco,

I tried but output is not coming.

[jagan]

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.

[tresesco]

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'))

[Anonymous · Accepted solution]

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')))