Hey @Jacob,
You have to connect the two filters with an OR statement:
FILTER (ORDER_NR = 37 AND DATE < 31-07-2018) OR (DATE = 31-07-2018)
Best,
Justin
Dear Justin,
We tried encoding your example in 3 ways, but none of the 3 works:
CODE:(LEFT(EBELN , 2) = 37 AND AEDAT < <%=startDate%>) OR AEDAT >= <%=startDate%>
FILTER (LEFT(EKKO.EBELN,2) = 37 AND EKKO.AEDAT < <%=startDate%>) OR (EKKO.AEDAT >= <%=startDate%>)
FILTER (EKKO.EBELN LIKE %37% AND EKKO.AEDAT < <%=startDate%>) OR (EKKO.AEDAT >= <%=startDate%>)
The
( ) do not work. Probably make the same reference as startDate, but to a string with left.
I just spoke to Robert about this and het asked me to reply on your email.



Hi @Jacob,
The following should be Code correct:
FILTER (LEFT(EKKO.EBELN,2) = 37 AND EKKO.AEDAT < <%=startDate%>) OR (EKKO.AEDAT >= <%=startDate%>)
Could you please check whether you defined <%=startDate%> correctly? You have to define a Date in the following format: {dyyyy-mm-dd}
Hi Jacob,
could you please try the code without the FILTER in front and let us know?
Thanks and best regards,
Viana
Hi Jacob,
please use proper single quotes around the 37. The ones copy-and-pasted from this forum dont work.
Best
David
Dear Justin,
We also tried this by entering the statement manually but it still gives an error message.:
image006.jpg1117392 39.5 KB
The same when we copy the statement and changed the single quotes around the 37.
Also Vivian asked us to remove the FILTER statement, but also again an error message
image007.jpg1102385 38.7 KB


