Difference between 2 dates of a proposal status

[actorres253aninha]

Dear All,

I´m new to Qlikview and I need some help.

I need to calculate the average time (in days) a proposal is treated according to its status. Just can´t find a way to do that.

Could someone help me?

[pradosh_thakur]

Your dates seems to be string by just looking at it. Can you confirm it?

You can use interval() function once they are converted to date/tiemstamp 

[Anil_Babu_Samineni]

Perhaps this?

Avg(TOTAL <STATUS> Num(Num#(Interval(START_DT - END_DT, 'DD'))))