I need to find a way to take the minimum date in a column by a group where there are lots of invalid dates (like 0000/04). So I thought of using some date (like 1900/01) as a parameter, and take the minimum value after that. Do you have any idea how could it be done?
As an example, my script is:
ID DATE(MIN(Mydate),'YYYY/MM') AS MinDate From  Group by ID;