YearFraction in Qlik

[sags]

Hello,

I am new to qlik and am trying to achieve the below excel formula in qlik. kindly help me with the Qlik equivalent expression for YEARFRAC and EOMONTH as in the excel formula below.

=YEARFRAC([@[min(UsageStartDate)]],[@[max(UsageEndDate)]],2)*12
+((HOUR([@[max(UsageEndDate)]])-HOUR([@[min(UsageStartDate)]]))
/(24*DAY(EOMONTH([@[max(UsageEndDate)]],0)))) 

 [@[min(UsageStartDate)]] and [@[max(UsageEndDate)]] are calculated expressions 

[vinieme12]

Unfortunately there is no Yearfrac in Qlik,  alternatively you can divide the (Difference in Days) / 365.24 for which results are close enough

for EOMONTH use the MonthEnd() function

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/DateAnd...