Hi All,

I've tried the following to format my date in 'dd/mm/yyyy' instead of 'dd/mm/yyy hh:mm:ss' when importing data from csv to DataSet.

CONVERT(VARCHAR(10), [dateColumnName], 103) AS [DD/MM/YYYY]

and

CONVERT(DATETIME, [dateColumnName], 101) AS [DD/MM/YYYY]

Both give me the error: Undefined function 'CONVERT' in expression

What would be the correct method for this?

The full query is:

SELECT DISTINCT(URN), [CanX Reason], CONVERT(DATETIME, [Date to take effect?], 101) AS [DD/MM/YYYY] FROM...

The first should be fine, you are running on SQL Server?

Yeah, the first looked fine to me too.
I'm using Microsoft.Jet.OLEDB.4.0.

I'm going to take a different approach as the main problem (the date formatting) is occurring when I create a new csv file from the DataSet.