The query is to see who has completed confirmation (just choose the date you opened your window for confirmation)
LIST STU ICL STU.ID STU.NM STU.PEM ICL.TC ICL.DT IF ICL.TC = "FinalDataConf" AND ICL.DT > "07/26/2017"
Here is a skip query for those who didn't complete it
SKIP STU ICL IF ICL.TC = "FinalDataConf" AND ICL.DT > "07/25/2017"
To set STU.VDT for Address Verification for all Students who have completed the data confirmation online:
Using Change Form:
LIST STU ICL STU.NM ICL.DT STU.VDT IF ICL.TC = "FinalDataConf" AND ICL.DT > "07/25/2017" AND STU.VDT < "07/25/2017"
Using Change Command:
CHANGE STU ICL STU.VDT TO ICL.DT IF ICL.TC = "FinalDataConf" AND ICL.DT > "07/25/2017" AND STU.VDT < "07/25/2017"
Thank you Doug Davis, Kingsburg High School