Skip to Content Skip to Menu

Assign to user group by two different date values?

11 years 5 months ago #216024 by tobiasknabe
You are right, I wasn't clear: how do I use / where do I set
date( 'FORMAT', '[cb_date]' ) as condition rule?
I am not quite sure where to set it. Otherwise I got your answer right.

What I am doing is:

at registration I offer a field called birthdate. The entered date, let say 1976-09-18 should be stripped and be compared to the date value of "virgin", which is between yyyy-08-24 and yyyy-09-23.
The date fields for "virgin" are not displayed during registration.
So what I need to know is, how to make the match between 1976-09-18 and 2012-08-24/2012-09-23, 2013-08-24/2013-09-23, 2014-08-24/2014-09-23 - maybe it is described a little more clear now. If there is a match, the user should be assigned not to registered but to the group virgin.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 68625
  • Thanks: 9110
  • Karma: 1434
11 years 5 months ago #216123 by krileon

You are right, I wasn't clear: how do I use / where do I set
date( 'FORMAT', '[cb_date]' ) as condition rule?

You don't, it doesn't exist yet. That's a feature ticket for next release.

at registration I offer a field called birthdate. The entered date, let say 1976-09-18 should be stripped and be compared to the date value of "virgin", which is between yyyy-08-24 and yyyy-09-23.
The date fields for "virgin" are not displayed during registration.
So what I need to know is, how to make the match between 1976-09-18 and 2012-08-24/2012-09-23, 2013-08-24/2013-09-23, 2014-08-24/2014-09-23 - maybe it is described a little more clear now. If there is a match, the user should be assigned not to registered but to the group virgin.

You're probably going to need to use a CB Query Field and do a database query for the field then do your comparison stuff there using MYSQL functions as the detailed comparison you need the conditionals can not do. You'd do the comparison in a query field with MYSQL then output a 1 for true and 0 for false then just check for 1 or 0 in your conditional.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum

Facebook Twitter LinkedIn