Current Date between months and condition is met

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)

Welcome to B:bob:B!

Which tool do you use? WebI or Crystal Reports or maybe something else?


Marek Chladny :slovakia: (BOB member since 2003-11-27)

Im using Business Objects, its very new to me :slight_smile:


ams256 (BOB member since 2020-06-02)