Hi Craig,

The FORMAT in SSRS did not work - I lost the value .

But here's what I did I right clicked the field , then in the Text Box Properties there is a Option called 'Number' clicked that it gave me sever options like Escel sheet gives and I selected Daate : mm/dd/yyyy.

Seems this is working.

Thanks again for helping and guiding me.

Kind Regards

Dhananjay