Wow.. awsome ..
Thanks dude , Its working now . Your second post was simple and effective . I just changed my database table to handle datetime in one single column because i keep getting this error "The data types date and varchar are incompatible in the add operator" when using CONVERT(DateTime, [Date] + ' ' + [Time]).
Anyway its working now . The result is what i needed.
Thanks for all the help .
Regards
Yathin

Greetings from singapore