Hi everyone,
I have a table with a field called "Due Date". I have 5 additional fields, lets say "Date 1", "Date 2", "Date 3", "Date 4", and "Date 5". I am trying to auto-populate the 5 additional fields with a formula based on the Due Date entered.
For example: If Due Date = 07-10-2023, then I want "Date 1" field to auto-populate based on this expression ("Due Date" less 5 days) = 07/05/2023. "Date 2" field to auto-populate based on this expression ("Due Date" less 10 days) = 07/05/2023 and so on.
Is this possible?
I have a table with a field called "Due Date". I have 5 additional fields, lets say "Date 1", "Date 2", "Date 3", "Date 4", and "Date 5". I am trying to auto-populate the 5 additional fields with a formula based on the Due Date entered.
For example: If Due Date = 07-10-2023, then I want "Date 1" field to auto-populate based on this expression ("Due Date" less 5 days) = 07/05/2023. "Date 2" field to auto-populate based on this expression ("Due Date" less 10 days) = 07/05/2023 and so on.
Is this possible?