I create an exposed filter with
- node post date
- cck field date (dataevento)
- date1 OR date2 conditions
- "is beetwen" conditions

I check in the query and post date doesn't appear.
____________

WHERE (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_dataevento.field_dataevento_value, '%Y-%m-%%dT%T'), SEC_TO_TIME(3600)), '%Y-%m-%%d') >= '2006-02-02' AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_dataevento.field_dataevento_value, '%Y-%m-%%dT%T'), SEC_TO_TIME(3600)), '%Y-%m-%%d') <= '2012-02-02') OR (DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node_data_field_dataevento.created), SEC_TO_TIME(3600)), '%Y-%m-%%d') >= '2006-02-02' AND DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node_data_field_dataevento.created), SEC_TO_TIME(3600)), '%Y-%m-%%d') <= '2012-02-02')

______________

Comments

merlinofchaos’s picture

Status: Active » Closed (won't fix)

Please read the issue submission guidelines regarding where issues about fields provided by modules should be posted.