2 Replies Latest reply on Sep 18, 2018 3:13 AM by kumar raman

    STR() - need more clarity please help

    kumar raman

      Hi All,

       

      I connect to a excel datasource.

      1. Created a calculated field

      str(DATEADD('month',-1,TODAY()))

      2. when I drag the calculated field to the rows shelf I get the value as below

      2018-08-18 00:00:00

      Now I connect to a oracle database and did the same steps but the output is different

      Aug 18 2018 00:00:00

       

      Why the output differs and I need the output to be in 2018-08-18 00:00:00 format irrespective of the datasource I connect to.

       

      Thanks

      kumar