date_difference + add_months combination in qlik

[Asiolinka]

Hi All,

I need to rewrite below query from another language (no idea which one it is - sorry for this).

1./and date_difference_months(date1=todaydate, date2=birthdate)/12<65

2.//and date1 >= date_add_months(in_date=todayday, months=120 )

Do we have sth like date_difference in Qlik? 

I tried filednameas: 

1. if ( ((('2023-05-09'- "birthdate")/12)<65),1,0)

2.(If( ((datetocheck) >= ( AddMonths('2023-05-09', 120) )),1,0)) 

Any ideas? another options? Both rules should be add to another check. 

[Chanty4u]

May be this 

if((Year(Today()) - Year(BirthDate)) < 65, 1, 0) as AgeCheck

if(Date1 >= Date(AddMonths(Today(), 120), 'YYYY-MM-DD'), 1, 0) as DateCheck

[Asiolinka]

if((Year(Today()) - Year(BirthDate)) < 65, 1, 0) as AgeCheck 

Is it possible to replace  (Year(Today()) by (Year(2023-03-31)) ?