Henry_Valevich - profile

Henry_Valevich · May 17, 2022

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...

Henry_Valevich · May 18, 2022

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.

Henry_Valevich · May 17, 2022

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...

Henry_Valevich · May 17, 2022

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...

User Statistics

User Activity

Increment Date Field by one month when another field changes value

Re: Increment Date Field by one month when another field changes value

Re: Increment Date Field by one month when another field changes value

Re: Increment Date Field by one month when another field changes value