By tiboe on

Hi

Webform submission with mySQL to View. Everything is working fine just the date showing the submission is always 1970 01 01. Can Anyone point a solution for this small glitch ? The date is correct in Data Tables , but in View is wrong.

⋅ Categories: Drupal 7.x

Comments

lzimmerman’s picture

lzimmerman commented

Hi tiboe,

I just came across this also. My webform data was coming through just fine in its view created by Webform MySQL Views, except for the submitted date. The field returned errors in the "View Records" pane for the data table, and was blank in views. When I switched date formats, I found that all submitted records had this default date.

The solution was this: ignore or remove the Submitted field automatically provided in your mysql view, and add a new one directly from the webform submissions data.

In your view, select: Add Fields -> (Filter) Webform Submissions -> Submitted.
Format this date field as you like, and it should display normally.

A hint was in the NodeOne video here:
http://archive.org/details/DisplayWebformSubmissionDataInViews

This video is for D6, but Johan mentions pulling in data via the Relationships settings. I didn't need to do that, but it reminded me that the date might be available in more than one place.