Good morning! I would like to know how I can make a query to get the results of my records depending on the date.
I have PEDPOS which is the order and I have CMOV which is the movement that was made (101 delivered 102 returned) I have the date on which each movement was made. CMOV
What I want to do is for example if an item that has:
PEDPOS CMOV FECHA 123 102 20-02-17 123 101 22-03-17
Here as you can see this order is already discarded because it was delivered, as, what I want to know is how I can do to get the ones that are not yet delivered as for example this one:
PEDPOS CMOV FECHA 124 102 15-03-17 124 101 23-03-17 124 102 04-04-17
The product has not yet been returned here as it was previously delivered but was returned again.