I need to know the difference between two dates as a number to use that to add to another date extending it’s duration.
Use case is as such:
- Customer has membership ending date XX/XX/2021
- They purchase another year of membership
- We need to know the difference between today's date and their end date
- Then add that to the 365 days they’ve bought to give us their new expiration date
I’ve stared at the formatter for a while but you can only use it with written expressions (i.e. +50days) to change a date rather than mathematical operation using two dates. Conversely the numbers utility won’t work with a date format.
I’ve had some kinda ideas but they all get very task heavy quickly so would be incredibly grateful if anyone has a solution to this!
Best answer by Troy TessaloneView original
Check out these related Community Topics:
Thanks for linking me.