HI all,
trying to find a way to automatically calculate a table entry based on a known, set date (DateReceived field) plus a choosable number from a list (CheckInterval field - choice between 30, 45 and 60 days) and the calculated value automatically entered into a "CheckDue" field for that record
Example would be a received date of 1st November 2019 with a 45 day interval before a status check has to be made.
Aim is to later run a report showing which documents are either due or overdue for checking based on the current date compared to the "CheckDue" date (will cross that bridge much later though)
Thought the DateAdd function might work, but it is not working as hoped (not working at all!)
huge thanks in advance
trying to find a way to automatically calculate a table entry based on a known, set date (DateReceived field) plus a choosable number from a list (CheckInterval field - choice between 30, 45 and 60 days) and the calculated value automatically entered into a "CheckDue" field for that record
Example would be a received date of 1st November 2019 with a 45 day interval before a status check has to be made.
Aim is to later run a report showing which documents are either due or overdue for checking based on the current date compared to the "CheckDue" date (will cross that bridge much later though)
Thought the DateAdd function might work, but it is not working as hoped (not working at all!)
huge thanks in advance