I am trying to use a set expression to count the number of orders closed today. I have read through other community posts but was unable to find a solution that worked for me. I am having some syntax issues but I have very limited experience with set expressions so I'm not sure what I'm doing wrong. Here is what I have now:
I want to count the distinct orders where OrderStatus = Closed and LastActivity date = a variable vToday. I have to do some timestamp formatting to get LastActivity and vToday to have matching formats. The error says error in set modifier. Is anyone able to tell me what is wrong with my expression/how to fix it?
Note: I use a variable vToday because there are some business cases where vToday does not equal Today()