Get Started with Redwood for Oracle Cloud HCM Begin Now
Error using Dynamic date
Summary
Getting error when using Dynamic date to beginning of the yearContent
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:
0