I have 2 fields: PrevDate and NextDate. When I change another field or add checkbox I need to increment NextDate by 1 month from PrevDate. I can use DATEADD({PrevDate}, 1, ‘month’) but then I need to change PrevDate so that I can use use it nest mont...
Hi. No, not from today but from NextDate. That’s the issue, it’s easy from today but NextDate already has a value that is not necessary today’s .
Thanks for trying.
Rupert,
I’m sorry I can’t explain myself properly. Let me show you my example table.
When I enter amount I have a formula in Paid Date as today’s date but now I need to bump up NextDate field by a month. I have to use the current value in NextDate a...
Hi Rupert, the formula works on next-day field since it’s using prevday field but then I need to change prevdate and I can’t use the formula since I get an error message circular…
Basically I need to bump up same field by 1 month. Every month due dat...
