We have an American client who has set Date Format in CB config to mm/dd/yyyy. In back-end CB user management date fields display as mm/dd/yyyy, but when he uses Search Tools to search a date field, he must enter the search value as yyyy-mm-dd . I presume that this is because the value entered is exactly the value used in the sql query, there is no reverse date string formatting, and database date fields are always yyyy-mm-dd
Displays fine in all my tests. It will always display exactly the same as profile edit because it's the same HTML code. A date or datetime field can override the global format though and perhaps that has been changed within the fields parameters.
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.
Thanks Krileon. Yes, search works fine front-end, but it's the back end user management list where he is having the problem. I suspect that he'll just have to put up with it
There are no changes in any date field params
Backend searching is against raw database value. So it needs to be in 0000-00-00 format. Yes, he'll have to put up with it as we currently do not output a fields actual edit usage there as the two usages are not compatible with one another at this time.
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.
krileon
