1. Forums
  3. Support and Presales
  5. Developer Members Support
  7. [SOLVED] CB User Mgmt search - specifying date value

[SOLVED] CB User Mgmt search - specifying date value

3 years 10 months ago - 3 years 9 months ago #319031 by fdinkler
[SOLVED] CB User Mgmt search - specifying date value was created by fdinkler
I'm attempting to filter users in CB User Management using a profile date field -

cb_license_exp_date - Less than - [value]
where [value] is a date constant.

I've tried '2020-06-01', 2020-06-01, '06/01/2020', 06/01/2020 without any luck
Clearly I'm missing something fundamental...
Fred

Please Log in to join the conversation.

3 years 10 months ago #319035 by krileon
Replied by krileon on topic CB User Mgmt search - specifying date value
You need to supply SQL formatted date. If it's a date field that would be 0000-00-00. If it's a datetime field it would be 0000-00-00 00:00:00. It currently doesn't do any integer conversion to make this easier so you have to be exact in the format or the query won't work as expected. So 2020-06-01 for example should've worked fine, which would add to the database query as follows.

 WHERE ( a.`cb_license_exp_date` < '2020-06-01' )

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 to join the conversation.

3 years 9 months ago #319231 by fdinkler
Replied by fdinkler on topic CB Subs: date value in CB Fields integration
I've create a profile date field - cb_mbrship_exp_date
For each plan defined, I added the following entry in the CB Fields integration:

Field: cb_mbrship_exp_date
Operator: Field = Value
Value [SUBSCRIPTION_EXPIRY_DATE]

This generates '0000-00-00' for every plan

Do I need to use a nested substitution to capture the actual date?
Thanks,
Fred

Please Log in to join the conversation.

3 years 9 months ago #319232 by fdinkler
Replied by fdinkler on topic CB Subs: date value in CB Fields integration
Disregard - I got it working using a nested substitution...

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

Fred
The following user(s) said Thank You: krileon

Please Log in to join the conversation.

Moderators: beat, nant, krileon
  1. Forums
  3. Support and Presales
  5. Developer Members Support
  7. [SOLVED] CB User Mgmt search - specifying date value
Time to create page: 0.193 seconds

Facebook Twitter LinkedIn

    You are here:  
  1. Home
  2. Forums
  3. Support and Presales
  4. Developer Members Support
  5. [SOLVED] CB User Mgmt search - specifying date value

Search

Login / Logout

User Menu