2 Replies Latest reply on Oct 22, 2018 10:40 AM by pavitra k

    Tableau error on date fields

    pavitra k

      select  order_date, order_no, to_char(ors.expected_date,'MM-DD-YYYY') as expected_date, shippment_mode from order_release_table group by order_date, order_no,shippment_mode order by  order-date This was a working fine  before TNS implementation but now it's failing with " ORA-01843: Not a Valid Month" Any suggestion on how to fix this problem... Have referred several other posts on a similar issue but still with the same error Env: Tableau 10.5 Version Oracle 10g and 11g