0

Data was received from a third party at 6:30 PM GMT.

  • Automation is scheduled at 8:30 PM (GMT) Dublin, Edinburgh, Lisbon, London
  • Business unit time zone : (GMT-05:00) Eastern Time (US & Canada)

Query :

SELECT emailaddress,
CAMPAIGN_EXECUTIONDATE
FROM   DataExtension
WHERE DATEDIFF(dd,GETDATE(),CAMPAIGN_EXECUTIONDATE)= 0

but it is not getting data from the source DE.

Please suggest what's wrong with the query or something else that I am missing. Thanks in advance.

I want to run the automation and fetch the data from source data extension and then trigrering the journey via this autimation.

James Z
  • 12,209
  • 10
  • 24
  • 44
Anil kumar
  • 3
  • 3
  • well, you should ask yourself, what does `DATEDIFF(dd,GETDATE(),CAMPAIGN_EXECUTIONDATE)` return. And if it doesn't return 0, that's your problem. – James Z Jan 31 '23 at 09:36

1 Answers1

0

Make sure the data fed to DATEDIFF is of same data type. I guess that's the problem

Vijay P
  • 43
  • 1
  • 4