Thanks for your suggestion. I am new to the company and it has been there for a long time and it is working before. I am not good at query...

also im getting this error.
when executing this
Msg 242, Level 16, State 3, Line 1
The conversion of a varchar data type to a datetime data type resulted in...