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

Error using Dynamic date

Received Response
edited Dec 13, 2022 7:03AM in Taleo Enterprise 2 comments


Getting error when using Dynamic date to beginning of the year


I am using the dynamic date filter to look for a hired date >= beginning of the year: TIMESTAMPADD(SQL_TSI_DAY, DAYOFYEAR(CURRENT_TIMESTAMP) * -(1) + 1, CURRENT_TIMESTAMP))

I am getting this error:

  View Display Error
Error getting drill information: SELECT "Submission Dates"."Submission Completed Date" saw_0, "Submission Source"."Submission Source Type" saw_1, "Submission Source"."Submission Source (BL)" saw_2, "Submission Dates"."Hired Date" saw_3, "Candidate Identification"."State/Prov of Residence" saw_4, "Requisition Primary Location"."Location Level1 Code" saw_5, "Candidate Identification"."Candidate Identifier" saw_6, "Requisition Primary Location"."Location Level2 Name" saw_7, "Requisition Identification"."Req. Identifier" saw_8, "Candidate Identification"."Candidate Is Internal" saw_9, "Requisition Identification"."Title (BL)" saw_10, "Submission CSW Status - Current"."Current Status Name" saw_11, "Submission Source"."Submission Source Explanation" saw_12, "Requisition Flex Fields"."UDF20" saw_13, "Requisition Primary Location"."Location Level3 Name" saw_14, "Candidate Identification"."Zip Code of Residence" saw_15, "Candidate Identification"."City of Residence" saw_16, "Requisition Organization"."Organization Level4 Name" saw_17, "Requisition Organization"."Organization Level3

Howdy, Stranger!

Log In

To view full details, sign in.


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