1 Reply Latest reply on Aug 27, 2015 8:19 AM by user13816768

    Evaluate function for Date

    user13816768

      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