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.
Format UDF Attribute from Plain Text to Date?
Summary
I have a UDF that is in plain text format but I need it be able to filter on a time period.Content
My UDF is Relocation Date. The screenshot shows the current Data Format. I wanted to filter on this field to apply the sql using the In Between Operator.
Greater than or equal to timestampadd(SQL_TSI_DAY,-30,CURRENT_DATE)
Less than or equal to CURRENT_DATE +1
But I can't do that because it's in plain text. Does anyone have any suggestions?
Thanks,
Margaret
Tagged:
0