For the first question, SQL Syntax could be like this:
Select * from SALES where SALES_DATE > '2009-12-3' if that's your correct date format.
or Select * from SALES where year(SALES_DATE)>=2010
for the second question, you could use and expression instead of a field. Then, your expression could be something like this:
= if( SALES_DATE>=makedate(2010), SALES_DATE)
The problem is: if you create a date-based chart, this expression on a list will not prevent the data from showing on the chart for 2009, for example. You would have to change all the expressions for that.
It`s better to solve it with question 1, because you application will use less memory and have better performance.
Hope it helps,
I must be doing something wrong, because it does not let me put the condition there.
I tried to put a condition on another field (DOKNR), just to sure it is not a date-format isssue, but it does not work. What am I doing wrong?
SQL SELECT ARTNR,
It`s really strange. In the mean time, you could load all the data and then keep only what you need.
It would be something like this:
Select * from SALES
Load * resident tempSales
drop table tempSales;
QV 10 will probably not recognize the `noconcatenate` but it works.