I want to define a filter on view saying something like "display job vacancies whose closing date is today or any day in the future". For this purpose, there is a keyword 'now' (the documentation reads as "Enter 'now' to use the current time") which should be translated to the NOW() function of MySQL. What happens, though, is that the SQL query looks something like

SELECT node.nid, 
       node_data_field_job_title.field_job_title_value AS node_data_field_job_title_field_job_title_value,
       node_data_field_job_branch.field_job_branch_value AS node_data_field_job_branch_field_job_branch_value 
FROM dr_node node LEFT JOIN dr_content_type_job_vacancy node_data_field_job_closing_date ON node.vid = node_data_field_job_closing_date.vid LEFT JOIN dr_content_type_job_vacancy node_data_field_job_title ON node.vid = node_data_field_job_title.vid LEFT JOIN dr_content_type_job_vacancy node_data_field_job_branch ON node.vid = node_data_field_job_branch.vid 
WHERE 

( REPLACE(node_data_field_job_closing_date.field_job_closing_date_value,'T',' ')

>=

'ERROR') LIMIT 0, 100

where the 'now' keyword got translated into 'ERROR' instead of 'NOW()'. I suspect that this is a fault of date module but I am not sure. Can anyone confirm this or suggest what to do?

Comments

Borek-1’s picture

Status: Active » Closed (duplicate)

Sorry, this is duplicate. See http://drupal.org/node/122124