Days Aging Inquiry

[verde0903]

Hello,

I have searched in the community for a solution but not finding the solution.  Am trying to find a formula that says that if today's date is September 10, 2024 and the invoice date is September 1, 2024, the invoice is aging x number of days.  In short, need assistance with a formula that returns the days variance between today's date and a set date.

Thanks,

Maylen

[DataNath · Accepted solution]

Hey @verde0903, you'll want to use the DateTimeDiff() function in conjuction with DateTimeToday(), using 'day' as the measurement.

DateTimeDiff(DateTimeToday(),[SetDate],'day')

Just replace [SetDate] in the expression above with your own field/set date. If you're hardcoding, just use a date in ISO format (YYYY-MM-DD) wrapped in quotes i.e. '2024-09-01'.

[verde0903]

Thank you DataNath, that worked perfectly.  Exactly what I needed.