ToString error in SQL Server link to Teradata

Connectivity

ToString error in SQL Server link to Teradata

Hello,

I am trying to query some Teradata data in SQL Server. When doing so, I get an error, "Cannot find either column "XDate" or the user-defined function or aggregate "XDate.ToString", or the name is ambiguous.

Now, I know the column exists and I can pull the date just fine in SQL Assistant. What do I need to do to be able to pull it in SQL Server?

Thanks in advance!

SELECT     Order, XDate FROM         OPENQUERY(TERAPRODLINK,

                      'select Order,min(XDate)  as XDate FROM table1 ')