I've been having some trouble with DATE search field. It appears it's only possible to search by complete date, such as "Nov 13, 2008", but this is not very practical: you might regularly want to look for a whole year content and it's not very user-friendly to have to go to advanced search all the time.
I've tried to set it as "Number" at User-Defined Columns but doesn't work because I guess it doesn't look trough built-in date field, is it?
Thank you very much for your help, it's driving me crazy and it's such an important field at the same time,
2 thoughts, first, you might want as a best practice, to use ISO formatted dates. Way easier to deal with (2013-02-19). This not only sorts dates more correctly (year, month, day) it's a standard for dealing with other systems as well so you don't have to translate.
Secondly, I've seldom used simple searches on anything date related mostly due to the extra granularity you can get by searching within x days of a date in advanced.
Try changing your date format and see if that helps in the basic search window. Mine searches fine with ISO dates.
Performing proper date searches on user-defined date fields is something we're addressing in a future update (which involves both server and client changes). For now you should know that internally these fields are stored as an ISO string, regardless of how they are displayed, so to search for clips from December 2012 you could search where field starts with "2012-12", and so on.