Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Error using Dynamic date — Cloud Customer Connect
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
41
Views
2
Comments
edited Oct 5, 2016 5:55PM in Reporting and Analytics Taleo Enterprise 2 comments

Summary

Getting error when using Dynamic date to beginning of the year

Content

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:

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
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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