2 Replies Latest reply on May 30, 2018 11:55 AM by Marvin Mondejar

    Dynamic Expression with to_char() and dateformat

    Marvin Mondejar Seasoned Veteran

      Using IDQ Developer, I have a dynamic expression that says:


      iif(is_date(to_char(AllFields)),to_char(AllFields),'n') and it runs fine,


      but when i want to add formatting, its throws and error.


      iif(is_date(to_char(AllFields)),to_char(AllFields,'yyyy-mm-dd hh24miss'),'n')



      [LDTM_0042] The mapping cannot be validated because of the following errors: [The port [Dynamic1] in the transformation [exp_NaturalKeyText_ChecksumPrep0] contains an expression that is not valid. Error: <<PM Parse Error>> [AllFields)),to_char(AllFields,'yyyy-mm-dd hh24miss'),'n')]: invalid symbol reference


      The error is not even pointing to the formatting i added.


      Any ideas?