I'm in the process of setting up a triggered automation that follows the process Upload to FTP > Import > Wait > Query > Wait > Send Email (to the target data extension of the query). I'm currently using the following simple query to dump all records created today into a data extension:
SELECT * FROM SCAAll
WHERE CreatedDate = DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)
CreatedDate is set in the data extensions to populate the current date by default - this isn't dictated by the import that happens prior to the query. All of the imported records show today's date as the CreatedDate. For some reason, the records don't make it into the target data extension. Any ideas why this might happen? An issue with the query, or the date field itself? Let me know if I can provide any more information.