'Cannot recognize date format' in SearchBuilder

[torrance123]

I'm using SearchBuilder to return me all contacts who have an activity (any activity will do, right now) whose date is after a certain date. I'm getting this error:

Code: [Select]

Cannot recognize for 20120816
The search is set up simply as record type = 'Activity', and then 'Activity Date' from the next menu, operator is '<', and the date is of the format '20120816'. I've also tried the date in a mysql datetime format of '2012-08-16 00:00:00', also with no luck.

The full stacktrace is here:

Code: [Select]

Sep 25 23:21:16  [info] $Fatal Error Details = Array
(
    [message] => Cannot recognize  for 20120816
    [code] =>
)


Sep 25 23:21:16  [info] $backTrace = /sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 300
/sites/all/modules/civicrm/CRM/Utils/Type.php, fatal, 221
/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php, escape, 4359
/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php, buildClause, 1909
/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php, restWhere, 1489
/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php, whereClauseSingle, 1527
/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php, whereClause, 458
/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php, initialize, 419
/sites/all/modules/civicrm/CRM/Contact/Selector.php, __construct, 215
/sites/all/modules/civicrm/CRM/Contact/Form/Search.php(924) : eval()'d code, __construct, 9
/sites/all/modules/civicrm/CRM/Contact/Form/Search.php, eval, 924
/sites/all/modules/civicrm/CRM/Contact/Form/Search/Builder.php, postProcess, 381
/sites/all/modules/civicrm/CRM/Core/Form.php, postProcess, 246
/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Refresh.php, mainProcess, 75
/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 289
/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 228
/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 500
, civicrm_invoke,
/includes/menu.inc, call_user_func_array, 516
/index.php, menu_execute_active_handler, 21

Am I doing something wrong or is this a bug? I see another person reporting a similar/same problem here: http://forum.civicrm.org/index.php?topic=24948.0

[Eileen]

Torrance does adding 6 zeros give you the right format?

ie. 'YmdHis'

[torrance123]

The format "20120812000000" returns the same error:

Code: [Select]

Cannot recognize for 20120812000000

[joemcl]

I'm doing a search in Search Builder, looking for Activity Date <= 20120725, still getting the same error Torrance reported last September. Tried adding six zeros as well (like 20120725000000), makes no difference, still fails. Has this been fixed in newer versions? We're still on 4.2.9 . Thanks.

[Eileen]

Joe - test it on the demo site to see if it works there