Thanks guys. Cory you were right i was looking for something like max(getdate()) but then i just wrote a function of my own to cast the value to a datetime...