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
Thank you. We appreciate your input.
The status of this post will be updated as your request is being processed by TARGIT.
Until then, the post will remain here to gather further interest (more votes) and comments.
Best regards / Ole
Please sign in to leave a comment.