[SOLVED] delimiter date if statement

thanks for the reply. i see how this works, but can get it to...

issues:
1. do i use CB Auto Actions or CB Queries? - there is a Querie in Auto Actions. is CB Queries old now? ie CB Auto actions does everything?

2. do i need to create the field cb_memberexpresult to contain the 0 or 1 generated by the Querie?

3. when do i trigger the querie? what we have is a club with "committee members" in the frontend, altering "members" data. if the querie is triggered when "onAfterUserUpdate", will this update the committee member data or the member data that the committee member is altering?

4. when i enter the querie you suggested
SELECT IF( DATEDIFF( `cb_memberexp`, NOW() ) <= 0, 0, 1 ) FROM `#__comprofiler` WHERE `id` = '[user_id]'

it gets shortened down in the CB Auto Actions to
SELECT IF( DATEDIFF( `cb_memberexp`, NOW() ) = '[user_id]' is this normal?

5. does the querie update the sql table? should i see the result in phpmyadmin for the site, or does it not work that way?

thanks

1. do i use CB Auto Actions or CB Queries? - there is a Querie in Auto Actions. is CB Queries old now? ie CB Auto actions does everything?

Neither you need CB Query Field. It allows performing a database SELECT query and displaying its results as a field. This allows you to use it in your IF substitutions.

2. do i need to create the field cb_memberexpresult to contain the 0 or 1 generated by the Querie?

If that's what you want to name the field yes and no. You don't input anything except for the query. The field calculates the results from the query.

5. does the querie update the sql table? should i see the result in phpmyadmin for the site, or does it not work that way?

It doesn't update anything. It's just a select query.

excellent - got it working.

thankyou