I am trying to do a report to check if training has been completed for example various courses need to be completed within a 3 month period and then the next set of courses need to be completed within the next 3 month period and so on.
If the current date is within a specific 3 month period ie May, June or July then the training would be due, if the 3 month period is in the future then training is not due yet and if the 3 month period is in the past then training is overdue.
I am hoping to do this by using a variable, any help would be appreciated.
ams256 (BOB member since 2020-06-02)