Hi Support Team,
My Scenario is CB + CB Auto Action.
CB is used to register users who must enter an essential data: the date of their certification.
This certification expires every 3 years.
Therefore CB Auto Action must check that value and the day before the expiry date it must send an email to the user to inform him that the certificate has expired.

let's take an example.
John Doe registers and enters his certificate which will expire on July 31, 2020. CB Auto Action the night between 30 and 31 checks the date and if true, send the email.

For these functions, Kyle helped me. I did some tests. Everything seemed ok. But after a month of use, the system now has something wrong because it also sends notifications to users that expire in 3 years (December 31, 2023).

Please, consider that the user never logs in because in this case CB is not used to create a community. So it is the server with a CronJob that calls the string that triggers the trigger

These are the screens










thanks in advance.
denis

Hi Beat,

yes, in mysql the date format is correct.
And please, notice that the "already notified" field is also true on dates that are not correct.

thanks again