+ Start a Discussion

query daily activityHistories

Hi guys,


We need to get daily activityhistories data for all the customers to integrate into a legacy system. I tried to query like this:


Select (Select b.Id, b.AccountId, b.ActivityDate From ActivityHistories b where b.ActivityDate=today) From Account a 


Dose anybody know what's the problem in the query or it is another way that I should try? Thanks in advance.