In Exact Target I am trying to query the _Subscribers Data View to return the email addresses of everyone that was added to the list for the previous day.
Here's what I started with:
WHERE ListName = 'myList' AND DateJoined = DATE_SUB(CONCAT(CURDATE(), ' 00:00:00'), INTERVAL 1 DAY) AND Status = 'Active'
But NOW() and CURDATE() aren't supported in ET. I'm not sure what else to use.