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



      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.