Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Concat Dates
Summary
trying to concat week and yearContent
I would like to show the week and the year of a certain date in one column (9-2017)
CONCAT (WEEK_OF_YEAR("Submission Dates"."Submission Completed Date") ||'-'|| YEAR("Submission Dates"."Submission Completed Date"))
I get a syntax error, I have played witht the parenthesis but is not working.
Help please
2