I am trying to pull send data from some scheduled sends. I am using below query:
SELECT s.SubscriberKey as Email_Address, s.EventDate as SendTime, s.JobID as JobID, d.VER as VER, d.CellMarket as CellMarket from _Sent s inner join [Source DE for Monitoring] d on d.Email_Address = s.SubscriberKey where s.EventDate between '2019-10-15 06:00:00 PM' and '2019-10-16 11:00:00 AM'
This is the time when my automation run. It is in pacific. It gives me very limited records as compared to the actual sends went.
When I use EventDate between
dateadd(d,-1,getdate()), it gives me more records but still not matching with the exact sends. I have also tried using hours(hh) instead of days(d) but not working.
All the automation run between 5 PM PST to next day 9 AM PST. I am aware that the Server time is CST irrespective of daylight savings.
I am not sure where I am missing on the time?