Special Date Search

Tagged:

Currently contains 4 posts

Avatar

August 29, 2019 15:56

hirenexus

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.

Avatar

August 29, 2019 15:57

hirenexus

It messed up my search:

MONTH ( ArrangedDate ) eq 08

Avatar

August 29, 2019 17:04

Jarrid-PCRecruiter

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.

Avatar

August 29, 2019 19:15

hirenexus

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.

Reply to thread