Completed
Calculate Date Difference based on Dynamic Date Origin
We have several needs to calculate Date Difference (Aging for inventory, invoices, POs, etc) that need to be dynamic. Meaning, if the user changes the Dynamic Date Origin, that needs to be recalculated to show as of month end, for instance.
Currently what we have to do is calculate this in the background, in a different table, for each day/month we need.
It would be great if the Dynamic Date Origin could be passed on to the DateDiff function and it returns the new result instead of relying on new tables. It would save a lot of time, development and database space.
2
Comments
Good News!
We have released a feature where you can obtain this functionality with Date calculations in the client.
[Cloud release: 2025.09.17]
[On-prem release: 2025 October]
[On-prem build: 25.10.10001]
Details here: https://community.targit.com/hc/en-us/articles/22281618270236-Date-calculations
Best regards / Ole
Please sign in to leave a comment.