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
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Isssues with PER_ASG_ATTRIBUTE_DATE2 database in Fast Formula
Content
Hello experts,
I've successfully validated the following fast formula:
default FOR PER_ASG_ATTRIBUTE_DATE2 is '0001/01/01 00:00:00'(DATE)
dataesodabilita = PER_ASG_ATTRIBUTE_DATE2
return dataesodabilita
It works as it should, but I need to solve the following issues:
1) There are some employees with PER_ASG_ATTRIBUTE_DATE2 null, but when launching the fast formula it displays 0001/01/01 00:00:00 instead of null value. In this case I would like the FF returns a null value and not the 0001/01/01 00:00:00 date format.
2) The Fast Formula returns the date in the following format:
|
2030-07-05T00:00:00.00Z |
Is there a way to return the following format:
0