Hi Lynn,

that will not help since in my case one of the dates can remian NULL hence if that's the case then it will not work using > , = etc; hence datediff

thanks

Dhananjay