Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Try Interval Function .
Expression :- Interval(Date -Today(),'DD' )
It works but not with selected dates :
Count({$<Interval(MakeDate(Année,Mois,Jour)-ContratTravailDate,'YY')={"<1"}>}%ContratTravailID)
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)
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)