I am pulling the data from eloqua with activitydate in them. I would like to use this Advance Data filter to bring in only yesterday's data. Is there a way to do it?
tried many different formats of this - trunc(ActivityDate) Trunc(CurrentDate-1). But no luck.
Any suggestions. I would like to make the Eloqua activity data pull for only 1 day.
try using $lastrundate parameter in the filter
You will have to check first if Eloqua supports $lastrundate and $lastruntime parameters
List of connector guides: Cloud Data Integration Connector Documentation