Get Started with Redwood for Oracle Cloud HCM Begin Now
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.
Get table value date in fast formula
Summary:
Unable to get date which has been defined in table values.
Content (required):
We have created table values based on column Date, and defined value as date. but when we call it fast formula it's not being called an getting an error.
DEFAULT FOR Policy_Date IS '1901/01/01' (date)
Policy_Date = GET_TABLE_VALUE('XX_INCREMETN_POLICY', 'PERIROD_INFOMRATION,'STARTING_DATE')
DEFAULT FOR Policy_Dat IS 'X'
TO_CHAR(GET_TABLE_VALUE('XX_INCREMETN_POLICY', 'PERIROD_INFOMRATION,'STARTING_DATE'),'DD-MON-YYYY')
I have tried to get date as date and Character as well but in both way getting an error.
Tagged:
0