Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Evaluate function for Date

user13816768Aug 27 2015 — edited Aug 27 2015

Hi All,

We have included a condition in the where clause of a logical table for a date field.

Evaluate('to_date(%1,%2)',"abcd".""."123"."Dim_SALES"."CREATED_DATE" ,'DD-MON-YY') > '01-JAN-15'

Now we have changed the data type of this field to timestamp and the above function is not working.

Can you please help me in getting this formula work for a timestamp.

Thanks

This post has been answered by user13816768 on Aug 27 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 24 2015

Added on Aug 27 2015

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

1 comment

342 views