CiviCRM Community Forums (archive)

I am using Drupal Views version 7.x-3.5 to create a monthly calendar grid, as well as a block of upcoming events.  The block of upcoming events works fine.   But the monthly grid does not.  It seems the issue is Views is attempting to use the MySQL function "FROM_UNIXTIME" for the start_date field, which returns a null.    Why is this function even being used for this field?

In troubleshooting, the SQL generated by the Drupal view for the monthly grid is as follows:

SELECT civicrm_event.title AS civicrm_event_title, civicrm_event.id AS id, civicrm_event.start_date AS civicrm_event_start_date
FROM
{civicrm_event} civicrm_event
WHERE (( (civicrm_event.is_active <> '0') AND (civicrm_event.is_public <> '0') )AND( (DATE_FORMAT(ADDTIME(FROM_UNIXTIME(civicrm_event.start_date), SEC_TO_TIME(-14400)), '%Y-%m') >= '2013-06' AND DATE_FORMAT(ADDTIME(FROM_UNIXTIME(civicrm_event.start_date), SEC_TO_TIME(-14400)), '%Y-%m') <= '2013-06') )AND(( (civicrm_event.is_template = '0') )))
ORDER BY civicrm_event_start_date ASC

(CiviCRM is version 4.2.7)