Loading SQL Records to review oldest date recorded.
Below is a script to load data which contains multiple records for each Plate Code, for example the plate may have been used last week and made 1000 items against a job number then again today for a different job for 500, i would like to select either via script or expression the must recent date that the plate was last used for review. below is script and example of basic table showing a plate used on two dates. (So i want to for review only use 06/05/2013?
Thanks but unfortunately not working, i just need to se the last or latest record info for the Plate code. if the plate has run 3 times in the last 4 weeks or whatever the time is i need to see the record for the last run date if for example that was today, hope this makes sense?