You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Filter hire start date with only previous month

Received Response
20
Views
13
Comments
edited Dec 1, 2020 5:46PM in Reporting and Analytics Taleo Enterprise 13 comments

Content

Ok, I'm trying to run a report that involves only showing those that had a hire start date of the previous month.

For the column I'm using MONTHNAME("Submission.Dates"."Hire Start Date") so that the column only shows the month.

Then I'm filtering that using the TIMESTAMPADD command like this because I only want the previous month:

MONTHNAME("Submission Dates"."Hire Start Date") = TIMESTAMPADD(SQL_TSI_MONTH, -1, CURRENT_TIMESTAMP)

I know there are results because without the filter I see Nov in the column I created. But when I add the filter, it throws an error:

Error Codes: 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!