I have a database containing testing information. My problem is that for each test there is an associated date and subtests within that test. A specific subtest may not have been done for a test, if this is the case I want to be able to find the date for the last test like it that was done. Basically I want to know how to be able to find the date in the past that is closest to the date associated with my current test. Does anyone know of a good way to go about this?
Thanks in advance,
James
Thanks in advance,
James