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