Thanks but once I've converted it to a date type I think I can do it just by comparing it to date(). The format is always going to be the same because I've got a little calender set up which the user chooses the date from rather than entering charcters.

Phil