[SOLVED] delimiter date if statement

hello

is there a simple way to add the following to a delimiter field?

[cb:if CURDATE() > cb_memberexp] YOUR MEMBERSHIP HAS EXPIRED [/cb:if]

i am trying to do the obvious here, but just cant seem to get it to work?

thanks

www.allmysocials.com/directory/tutorials/item/233-substitution-usage

e.g. [cb:date format="Y-m-d" /]

returns now.

BTW - if you need better support then consider upgrading your membership.

hi again and thanks everso much for the help, i just cannot seemto make it work.

using your reply, would this work, because it doesnt seem to...

[cb:if [cb:date format="Y-m-d" /] > cb_memberexp] YOUR MEMBERSHIP HAS EXPIRED [/cb:if]

i have tried all sort of permutations, it just doesnt seem to come together to do the comparison between the dates

sorry for the hassle, but are you able to give me some clues i would really appreciate it.

thanks

i have tried all these cb:if and these are the results

anyone who can help please. i feel i am close, but just cant crack it

thanks

cb:if

last visit date [lastvisitdate]

member exp [cb_memberexp]

today [cb:date format="Y-m-d" /]

1[cb:if cb_memberexp < "2012-12-31" ] EXPIRED [/cb:if] membership < 2012-12-31

2[cb:if cb_memberexp < lastvisitdate ] EXPIRED [/cb:if] membership < lastvisitdate

3[cb:if lastvisitdate < "2012-12-31" ] EXPIRED [/cb:if] lastvisitdate < 2012-12-31

4[cb:if cb_memberexp < [cb:date format="Y-m-d" /] ] EXPIRED [/cb:if] membership < today

5[cb:if [cb:date format="Y-m-d" /] < "2012-12-31" ] EXPIRED [/cb:if] today < 2012-12-31




results

last visit date 2012-03-04

member exp 2012-01-31

today 2012-03-05

1 EXPIRED membership < 2012-12-31

2 membership < lastvisitdate

3 EXPIRED lastvisitdate < 2012-12-31

4 membership < today

5 today < 2012-12-31

You can't use substitutions inside of substitutions. To have what you're wanting you'll need to use a CB Query Field to calculate the date difference of your field to NOW() then output a 1 if it's greater and a 0 if it's not. Then in your IF statement you'd compare against that CB Query Field. Below is an example query and IF statement of this usage.

Title: cb_subscribed
Query:
The above takes the difference in days between cb_memberexp and current datetime. It then checks if that value is less then or equal to 0 meaning expired. If it is expired it returns a 0 and if it's not it returns a 1. You could then use the above CB Query Field in the below IF statement.

[cb:if cb_subscribed="0" ]EXPIRED[/cb:if]