Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
theboss-123
Creator II
Creator II

Calculate difference between two dates

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

Labels (1)
  • SaaS

1 Solution

Accepted Solutions
mpc
Partner - Specialist
Partner - Specialist

Hi,

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

maximepiquetcointe_0-1712743744044.png

 

From Next Decision and mpc with love

View solution in original post

1 Reply
mpc
Partner - Specialist
Partner - Specialist

Hi,

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

maximepiquetcointe_0-1712743744044.png

 

From Next Decision and mpc with love