By amirn on
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
This appears to be a bug in
This appears to be a bug in TW. I've submitted it here: http://drupal.org/node/852880
same error/bug
I found same error.
My date fields show the same value:
01/01/1970 - 02:33
any idea for fix this?
Same here
Help Two days fo fighting I still can't find any solution.