8 Replies Latest reply: Sep 28, 2017 9:52 AM by Aurélien Martinez RSS

    SQL WHERE condition by Year (In Load Script)

    Yaniv Ben Malka

      Hi,

       

      I am uploading data through ODBC connection, with SQL SELECT statement.

       

      I want to add a WHERE clause by year (Year >=2017).

       

      My dates are formatted as string ('DD.MM.YY'). Therefore I will probably need to use 'Right' function (But I'm open to other ideas as well).

       

      What will be a valid syntax for this condition?

       

      I repeat, I am not referring to an upload from a Qvd file.

       

      Thanks in advance.