ETL and Data Integration tools - Modern ETL software for everyone

Good afternoon,

I’m trying to build a simple query using VIP and ANSI SQL/92 to create some SQL code I can put into a package.
I can’t seem to get past the date syntax in VIP. The code generated below always gives syntax errors.
Is there a particular syntax I need to use for dates to go against a Foxpro DB in VIP? What should I see in the SQL code?

Thanks,
Joe

you should use odbc date format eg

yyyy-mm-dd

The format is dictated by the odbc driver

Mike

It works

Thank you for the help

Joe