Self-hosted
Is there a formula that can take the date in date field(‘Purchase Date’) and create a new date in the future based on the number in formula field field(‘Days Until Resupply’)? Thank you for your help.
Hi @pyrebird welcome to the community!
This is more tricky than first appears as adding a number to a date can only be done using a date interval or duration and your formula result is of the type number. So first you would want to wrap the formula’s number value as a date_interval and then add it, but date_interval requires it to be text, so you need to first make it text before doing that! This would be your end result:
field('Purchase Date') + date_interval(totext(field('Days Until Resupply')) + " days")
