Error

Error message

PDOException: SQLSTATE[22007]: Invalid datetime format: 7 ERROR: invalid input syntax for type timestamp: "finance-01-01 00:00:00" LINE 7: ...eld_published_date0.field_published_date_value >= 'finance-0... ^: SELECT field_data_field_published_date0.entity_type AS entity_type, field_data_field_published_date0.entity_id AS entity_id, field_data_field_published_date0.revision_id AS revision_id, field_data_field_published_date0.bundle AS bundle, field_data_field_published_date2.field_published_date_value AS field_data_field_published_date2field_published_date_value FROM {field_data_field_published_date} field_data_field_published_date0 INNER JOIN {field_data_field_published_date} field_data_field_published_date1 ON field_data_field_published_date1.entity_type = field_data_field_published_date0.entity_type AND field_data_field_published_date1.entity_id = field_data_field_published_date0.entity_id INNER JOIN {field_data_field_published_date} field_data_field_published_date2 ON field_data_field_published_date2.entity_type = field_data_field_published_date0.entity_type AND field_data_field_published_date2.entity_id = field_data_field_published_date0.entity_id INNER JOIN {node} node ON node.nid = field_data_field_published_date0.entity_id WHERE (field_data_field_published_date0.field_published_date_value >= :db_condition_placeholder_0) AND (field_data_field_published_date1.field_published_date_value <= :db_condition_placeholder_1) AND (field_data_field_published_date0.deleted = :db_condition_placeholder_2) AND (node.status = :db_condition_placeholder_3) AND (field_data_field_published_date0.entity_type = :db_condition_placeholder_4) AND (field_data_field_published_date0.bundle = :db_condition_placeholder_5) ORDER BY field_data_field_published_date2.field_published_date_value DESC; Array ( [:db_condition_placeholder_0] => finance-01-01 00:00:00 [:db_condition_placeholder_1] => finance-12-31 23:59:59 [:db_condition_placeholder_2] => 0 [:db_condition_placeholder_3] => 1 [:db_condition_placeholder_4] => node [:db_condition_placeholder_5] => magazine ) in field_sql_storage_field_storage_query() (line 760 of /var/app/current/modules/field/modules/field_sql_storage/field_sql_storage.module).
The website encountered an unexpected error. Please try again later.