0 Replies Latest reply on Mar 8, 2019 7:09 PM by 2838586

    how do I format a date MM/DD/YYYY HH:MM:SS in  default_where statement?

    2838586

      I'm trying to format a date in a default_where statement and I cannot get it to parse correctly.

       

      Set_Block_Property('EPB_RECS_MODIFIED_TODAY',DEFAULT_WHERE,

             'corp_no = ''' || :eftpart.corp_no

             || '''' ||' and appl_no = ''' || :eftpart.appl_no

             || '''' ||' and class_cd = ''' || :eftpart.class_cd

             || '''' ||' and part_key = ''' || :eftpart.part_key

             || '''' ||' and to_char(date_last_maint, ''MM/DD/YYYY HH:MI:SS'') = to_char('||:global.date_last_maint ||',''MM/DD/YYYY HH:MI:SS'')';