Is it possible to do a search similar to SQL/MySQL. For example, I want to find all of the interviews that have taken place in the month of August, no matter what year:
MONTH eq 08
I tried it in the Resources Definition area but got zero results, which is obviously not the case.
It messed up my search:
MONTH ( ArrangedDate ) eq 08
I can double check with development but from testing it doesn’t appear to allow you use to the MONTH function. What you could do is pull all interviews, filter them yourself and then use the interview IDs that are returned to build a second query that returns just the values you’re looking for.
Thanks Jarrid. That seems like a really time-consuming process as far as timeouts go. I’ll just change the functionality so you have to select a year to view a month. Thanks.