ETL and Data Integration tools - Modern ETL software for everyone

Hello there,

Is this correct way to export Visual FoxPro table to text file? Please advise where I’m wrong.

Data connection is ODBC (Visual FoxPro); Its work only when I do not use now() function but I want export only today’s records.

Please advise.
Thx,

Have you tried CURDATE( )?

msdn.microsoft.com/en-us/library/ms714697(VS.85).aspx

Mike

Yeah, same error.

This one did work for me

SELECT * from table1 WHERE d=date()

John

You guys just simply great; its work with this. Rock!!!

Thx