Get Started with Redwood for Oracle Cloud HCM Begin Now
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