1. I have tried limiting my load statement based on results having a completion date >= 5/21/2016. I can not figure out the syntax of the where statement and I am not sure a where statement is the correct option. Blow is my script I removed the where statement.
LOAD [User ID] as AGT_6,
[User Full Name],
[User Orig. Hire Date],
[Training Object ID],
[Transcript Completed Date],
DATE(Subfield([Transcript Completed Date],' ',1), 'MM/DD/YYYY') as Trans_DATE,
NUM(Subfield([Transcript Completed Date],' ',1)) AS Trans_DATENUM,