I am trying to use this query to add records with a 'dateofApplication' date of 15 days ago:
SELECT * FROM [UG Journey Master] WHERE [dateofApplication] = DateAdd(day,-15,GetDate())
Unfortunately, it adds 0 records to my data extension. The first part is correct, as when I use a different WHERE clause (such as Email_Address Like 'Z%') works fine. So there is something wrong with my DateAdd clause.
Can anyone help?