Solved: Re: Calculate difference between two dates - Qlik Community

theboss-123 · ‎2024-04-07

Hello everybody we have a. Accounting apps sage 50c to have the aged balance I need to calculate difference in days between today (current date) and invoice date but greater than 60 days

Can u help me plz

mpc · ‎2024-04-10

Hi,

Maybe something like that:
Today()-Only( {<[Date de la vente]={"<$(=Date(Today()-60))"}>} [Date de la vente]) ?

From Next Decision and mpc with love
It helps, like it, It solves, mark it

View solution in original post

mpc · ‎2024-04-10

Hi,

Maybe something like that:
Today()-Only( {<[Date de la vente]={"<$(=Date(Today()-60))"}>} [Date de la vente]) ?

From Next Decision and mpc with love
It helps, like it, It solves, mark it

Calculate difference between two dates

SaaS