WOW...I have spent hours testing this stuff!!!
SOOOOO.........I
was wondering if there was a bug with filtering by datetime...so I
decided to do a filter by a text field. In the menu item, i set 'options
tab' > Default order > use global, and IT WORKED to sort via
the text field.
I then went and changed the sort field in List and
Search back to my 'Event Start Date' datetime field, saved it, reloaded
the frontend, and IT WORKED!!!
Very strange. It seems by changing the filter field, it reset things to work. I'll see how things go.
I DO BELIEVE I HAVE FOUND A BUG HOWEVER.
In
the MENU ITEM, when you go to the 'options' tab > Default order
> COM_CCK_CUSTOM ....it doesnt matter what seblod field I add
here, it simply wont filter by it. Whether its text, calendar, etc..it
wont work. This has not worked for me in 3.5.1 and the new 3.6.0.
EDIT FYI
I did do one more thing that might be the reason why this started working to filter by the Event Start Date.
1) Some days ago I upgraded to 3.6.0 (but filtering by event start date didnt work after the update)
2) When i was testing filtering by a text field, I set the text filtering field to be my 'Event City' text field.
3) To make sure I could visually see if the filtering order was correct in the frontend, i went into every Event i had created, and I changed the 'Event City' and then saved the Event (article)
HYPOTHESIS 1 - as per the first idea listed above
HYPOTHESIS 2 - there was a bug in version 3.5.1 for filtering by datetime calendar field, and thus when I saved the datetime it didnt save correctly. Thus, after I upgraded to 3.6.0 and then re-saved every Event (article), it saved the datetime correctly, and thus the filtering of datetime calendar field is working correctly.
Can anyone confirm any of this?