Operator / operand type mismatch....

[Anonymous]

Hi,

I'm trying to the filter but somehow i get a script error. Please see syntax below

LOAD name,

         location,

         address;

SQL SELECT *

FROM XXX

WHERE trndat > '12/31/2011';

[alexandros17]

Probably date format is wrong, try to use trndat > '20111231';

[jvitantonio]

Hi, just in case don't use * in your SQL statement.  Names in SQL statement will be loaded in upper case. Do this:

LOAD NAME as Name,

LOCATION as Location,

ADDRESS as Address;

SQL

SELECT Name, Location, Address from xxx where trndat > '12/31/2011';

If this is not the case, please state what error you are getting.

[Anonymous]

Yes i have tried with that format,I'm extracting from Foxpro (.bdf) and "command is missing required clause" when i executed with the latter solution.

[Anonymous]

Hi guys managed to filter using the year function instead and it worked just fine ;

WHERE YEAR(notdat) > 2011;