CB Auto actions - auto mail

What variable shoulld I use to get the currentdate?

Basicly I want to achieve the following:
Trigger
Users

Type
Field

Conditionals
[cb_mydate] (with value 2016-02-03 from a date field)
is less then
the current date (don't know the according variable)


Action
Change field value

For dates to compare they need to be turned into timestamps. The below should work.


Value: [cb:parse function="time"][cb_mydate][/cb:parse]
Operator: Less Than
Value: [cb:parse function="time"][cb:date format="Y-m-d H:i:s" /][/cb:parse]

Thanks. If I place the conditions like this, does it places an AND function between this?
If the field is not empty AND the value is less then todays date do the action.
Or how can I filter out empty values because now I have the feeling the action also triggers users with fieldvalue 0000-00-00

To check against empty value use the following usage.

Date Fieldtype:
[cb_mydate] Not Equal To 0000-00-00

Datetime Fieldtype:
[cb_mydate] Not Equal To 0000-00-00 00:00:00

Don't run time conversion on it as strtotime gives weird results for those values. You may need to have a 3rd condition as follows.

[cb_mydate] Not Empty

Thanks, this seems to work.

I noticed you can use time parameters in conditions.

Value: [cb:parse function="time"][lastvisitdate][/cb:parse]
Operator: Less Than or Equal To
Value: [cb:parse function="time" time="-20 DAY"][cb:date format="Y-m-d H:i:s" /][/cb:parse]

Is this a correct way to mail users after inactivity of 20 days?

Yes, that looks correct. That should pass if they haven't logged in within the past 20 days.