Date Conversion Problem

[khasimvali85]

Hi Community,

Can any body solve this Error when i connect to data base Table showing error like

''ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Conversion failed when converting date and/or time from character string.''

I Change Given format below

,Convert(Varchar,[Date_Field],103) as Date_Field   is it right?

Thanks in Advance

Regards,

Khasim.

[#2]

Hello, I had a similar problem ...

103 is the code for the date format: DD / MM / YYYY

101 is the code for the date format: MM / DD / YYYY

if the date stored in your database is 101 format and want to convert to 103 you will have a format error.

Test format conversion at 101 ...

I hope to help you, greetings.