I have created an AS400 query that is ran daily and combines two files. One contains qty on hand and the other contains what is shipping that week. Is it possible to subtract each date from the qty on hand to show what is needed for what date?
Thanks in Advance