Delete the expired date 1

[neomax]

Hi, Everybody!

I make query for the deleting data with expired date on my database when the user call web application,

DELETE
FROM Table
WHERE CLDate < date();

It is working fine, when delete date that are "<" then today date, but not !!! matter what is the year!!

For Example:
if exp.day 12/01/2006 and 12/01/2007 it delete the both, but shouldnt delete the 12/01/2007!!
What is the problem??

 

[traingamer]

CLDate is defined as a 'Date' in the table?

 

[SkipVought]

I doubt that it is, given the symptoms.

Skip,

_[red][/red]

 

[SkipVought]

I'll bet its a NUMBER like 200612.

Skip,

_[red][/red]

 

[neomax]

Thanks a lot for traingamer !!

Yes, the CLDate not was defined like a Date