thanks eric, can you help me impliment just searching the year of my date column in database?
as for seaching with dd/mm/yyyy it does not work. by default when i run the wizard i end up with my date range input fields and besides them it says mm/dd/yyyy
if i seach the field with someones birthday of say 30/11/1980 it returns 0 results even though there is a result for this. however if i search 11/30/1980 it returns the matches fine.
so it does matter and i need it to support uk format please?