I am building a process to pull all jobs that completed within the last 24 hours. However, I am getting some jobs back with an End Time more than 24 hours ago. Not sure what I’m doing wrong.
First I assign this - ReportTimeFrameDays is an argument, and is currently set to 1:
TimeFrame = Now.AddDays(-ReportTimeFrameDays)
Then, in the Get Jobs activity I filter like this:
"EndTime gt "+TimeFrame.ToString("yyyy-MM-dd")+"T"+TimeFrame.ToString("hh:mm:ss")+"Z"
I then ConvertFromUTC to Eastern Standard Time to get the correct start and end times for each row. In my output, nothing goes back further than the previous day, as I would expect, but I do get results for that day that ended more than 24 hours ago. I’m sure that I’m doing something wrong in the filter, but I’m not sure what it is.