I am trying to send a message to everyone whose birthdate is in two weeks but the date is of a different format and the query thus returns 0 rows.
The query I am currently using is the following
SELECT FirstName, PersonEmail AS EmailAddress, Id AS SubscriberKey, Language__c AS Language FROM ent.[Account_Salesforce_1] WHERE PersonBirthdate = DATEADD(day, 14, cast(GetDate() AS date)) AND FirstName IS NOT NULL AND PersonEmail IS NOT NULL AND Id IS NOT NULL AND Language__c IS NOT NULL
The format that has been passed from Service Cloud is the following: Thursday, December 13, 1984 12:00 AM
To what type do I need to change the format in order to make this work?