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
Issue with creating variable using UDF
Content
I have a req UDF that is set as a date.
I'm trying to then create a variable to measure that days between the UDF date and current date. Which I think should be fairly simply, however, I'm running into a couple issues.
The first variable I tried to create was just RPO day: =DaysBetween([Requisition UDF Value 18];CurrentDate())
- I get a message that states invalid data -referring to UDF Value
So then I tried creating a different dimesion variable:called RPO Date: =ToDate([Requisition UDF Value 18];"MM/dd/yy")
Next I created this measure variable: =DaysBetween([RPO Date];CurrentDate())
0