I’d like to be able to round up dates to a specific future date.
Eg I’d like to create a new property against our deals which is a “payout date”. This takes a current date property we have (“project start date”) and groups deals by rounding up the project start date i to two groups for the “payout date”.
For the “payout date”, I’d like all deals with “project start date” between 1st-15th of each month to be given a 15th of the month “payout date”. For all “project start dates” between 15th and end of month, to be given an end of month “payout date”.
This allows us to run workflows to determine payments to some companies in our database.