Notes: Don't use CTOD() for dates anymore. It has ambiguity problems. Your example may mean 11 April or also November 4 depending on settings. Use other date notations such as DATE(2007,4,11) for example.
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry