[SOLVED] Show value or field with date condition

I would show the zodiacal sign for every user according to his/her birth date.

First I could create 12 fields, one for every sign, or I can create just one delimiter with 12 signs value and filter them with cb substitutions (if).

Now is it possible to set the condition on the range period for every zodiacal sign to show the correct sign?

You'll probably want to use CB Query Field to first just return the day and month of their birthdate field as CB stores year for date fields and that'll cause your IF substitutions to be a nightmare to get working. Then you can use multiple checks in your IF substitution like the below example.

[cb:if cb_birthday>="06-21" && cb_birthday<="07-22"]Cancer[/cb:if]

I'm trying to biuld the SQL query to extract only %m-%d but I cannot do it. Would you help me with the query please.

Thanks.

Please see the below MYSQL documentation.

dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html#function_date-format

Examples of the functions usage are already included with the DATE_FORMAT documentation. Example as follows with CB Query Field.

Oh right! I made a mistake in the query... it was syntactic correct except for the `cb_birthdate` where I used ' instead of `

Now the query fields give me only month-day value, but then the substitution you suggested me doesn't work:

[cb:if cb_querydata>="01-01" && cb_querydata<="01-20"]
<div class="zodiac-sign">
<img alt="Capricorno" src="images/icons/capricorno.png" height="128" width="128" />
<p>Capricorno</p>
</div>
[/cb:if]

Could this 'caused by the fact that CBQuery field do not store data in DB?

Could this 'caused by the fact that CBQuery field do not store data in DB?

Shouldn't matter with CB 1.9 as we updated it to use getFields API so calculated fields can be used. Add the field substitution (e.g. [cb_querydata]) to a delimiter field to test that it's outputting properly. Also try using "and" instead of "&&".