Hi,

I'm using Table Wizard to expose a mySQL table to Views.
I need a field of type date but I can't seem to define a field that will both display correctly and will allow me to filter it as date type.

What I've tried so far: creating in my mySQL table date fields of 3 types:
* Date - value display fine but Views filter threats it as String (that is, operators are starts-with, contains etc.)
* DateStamp - same as Date
* DateTime -Filter loks fine (that is, contains between, larger than etc.) BUT the disaply is showing a date 1970-01-01 03:33 for ALL rows, even thou each row has a different date value.

When I run the Views query directly in mySQL - the output looks good.

Any ideas?

Thanks.

Comments

emasters’s picture

This appears to be a bug in TW. I've submitted it here: http://drupal.org/node/852880

overaph’s picture

I found same error.
My date fields show the same value:
01/01/1970 - 02:33

any idea for fix this?

tiboe’s picture

Help Two days fo fighting I still can't find any solution.