I have set up a report (i also copied it about 40 times to run it every 15 minutes) and it does not run or it is not capturing the data correctly to send the email.
I set the Reports (multiple reports) to run at 8, 8:15, 8:30 etc…
My “If this is true” expression is:
AND([Closed_Status] = “Open”,[Creation_Date] >= TIMENOW() - “0:15:00”)
I did this to have the report look at the table ( Ticket Log ) and look at two conditions- Is [Closed_Status] = “Open” and is [Creation_Date] equal to or less than 15 minutes ago ( i did this to make it ONLY see the last “open” tickets in the 15 minutes.
This report sent me (as i am testing with my email) the correct email - but at 12 AM - they all sent…