1. I asked for a describe of your table, you didn't supply it. Granted you supplied the information that I actually was looking for, but you still did not do wjhat I asked. You will find that you will get answers much quicker if you provide the information that is actually asked of you.
2. Why on earth are your 'dates' being stored as strings. This is a very foolish idea.
3. Stop using IM speak. u = You, pls = Please,
4. You need to convert your strings into dates using the to_date function. Look up the syntax in the documentation (I know that you have been pointed to it many times before.)

Clearly your crystal balls aren't quite up to scratch seyed456. Instead of just jumping in with both feet and getting the answer wrong, how about we let avril actually post what she has tried (even though it would appear that she is completely unwilling to do this for some strange reason)

Obviously, users were creative while entering dates (or what they *thought* that might look like a date), such as 30th February or 12.30.2009 (dd.mm.yyyy) and similar. It is a mess which needs to be cleared up. Happy tyding!