Set Analysis / Calculating floating age

[ArnaudTML]

Hi,

How to calculate an age in relation to a selected date via set analysis ? (like a birthday or a employee's seniority)

Does the function "age" work ?

[raman_rastogi]

Try Interval Function . 

Expression  :- Interval(Date -Today(),'DD' ) 

[ArnaudTML]

It works but not with selected dates :

Count({$<Interval(MakeDate(Année,Mois,Jour)-ContratTravailDate,'YY')={"<1"}>}%ContratTravailID)

[raman_rastogi]

Hi, 

Try below expressions

Ex- Count(if( Interval(MakeDate(Année,Mois,Jour)-ContratTravailDate,'YY') < '1' , %ContratTravailID))

Or

Count({<  %ContratTravailID= {"=Interval(MakeDate(Année,Mois,Jour)-ContratTravailDate,'YY')<1"} >} %ContratTravailID)

[ArnaudTML]

It doesn't work...

I have hiring dates in date + numeric "ContratTravailDateEntreeReference" + seniority date in numeric "$(vDateAnciennete1An)" in a table :

But if I make this in a dynamic cross table with set analysis, the result is 0 :

Count( {$< ContratTravailDateEntreeReference = {"> $(=vDateAnciennete1An)"} >} %SalarieID)