I want to fetch data from sales cloud but the field i am using is date filed with the format :
The query i am using in marketing cloud activity looks like :
Select * from Contact_Salesforce WHERE BirthdayCurrentYear__c = GETDATE()
Records are coming into my sync data extension but not in standard data extension.
May be its due to the date format and
"BirthdayCurrentYear__c" this is the formula field in sales cloud.
Please suggest the best way to write a query so my sales cloud data will come into marketing cloud data extension.