Moving from SQL script to Internal Users trigger

I currently have a SQL script:

I would like to change this to do it in autoactions.
What it does is, if it's november or december, and the year+1 does not appear in 'cb_betalt' the user get's a flag set (cb_rykker).

I was thinking along the lines:

Is there a CB substition that gives me current month and year?

You can get the current month using the below substitution.

[cb:date format="m" /]

However your year + 1 condition will be an issue. With the current format function behavior it's not very easy to do as stacking functions doesn't work right now. For this I suggest a CB Query Field then condition against the query field, which would query for cb_betalt and add a year.

Is there a reason you're moving away from a query? The field action does a direct database query then sets the value in the user object. So using a direct query is fine unless you're needing the profile update trigger to fire, which the field action doesn't fire either.

Currently it's running from the CRON as a SQL script. So I get the flag set, but I can't do anything else.
It would be nice to be able to do other stuff as well, like send an email to the user, that the flag is set.

There's an email action which could be used to send an email to the user. You can use whatever actions you like on the Internal Users trigger and they'll fire when that URL is accessed on every user row; this can be a heavy process though.