2 Replies Latest reply on Nov 13, 2018 3:28 PM by Dan Cory

    How to Subtract number of days from date ?

    Jagdish Suthar

      I want to subtract number of days from date and want new date as a result. I create calculated field and used DATEADD function but when I used calculated field in the worksheet then it give an error of database.

       

      This is the Calculation:

      DATEADD('day',-[Planned Deliv Days],[Conf delivery date])

       

      And this is the error when I used above calculated field in the worksheet

      [Amazon][RedShift ODBC] (30) Error occurred while trying to execute a query: ERROR: function pg_catalog.date_add("unknown", numeric, timestamp without time zone) does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts.