Help With Query

Question

I want to fetch data from sales cloud but the field i am using is date filed with the format : MM/DD/YYYY.

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.

Can you please confirm if your standard DE has all the fields as compared to your standard DE? Also, is BirthdayCurrentYear__c a date field or a text field? and can you show me an example of the value in this field? — Brad Sapkota, Sep 3 '18 at 11:18
BirthdayCurrentYear__c field is a formula field with date data type in sales cloud and sync DE and standard DE has same field. — user59741, Sep 3 '18 at 11:22
sure. are you trying to query the current year birthdays or birthday which falls today? — Brad Sapkota, Sep 3 '18 at 13:10

Johannes Schapdick · Accepted Answer · 2018-09-03 14:27:46Z

0

Maybe two things.

Ensure the DE has a primary key
GetDate() will have hh:mm:ss in addition. You may need to try a query where it's only for a specific day, since you are using =. If the hh:mm:ss aren't matching, then the query won't work.

2,6902 gold badges4 silver badges24 bronze badges

answered Sep 3 '18 at 13:15

Harley

3021 gold badge2 silver badges13 bronze badges

add a comment |

1 Answer 1