Hmmm .. the syntax is right, but why the RedShift error ?
How are you using the calculated field ?
Nice bug! You can work around it by changing your calculation to DATEADD('day',-INT([Planned Deliv Days]),[Conf delivery date])
The underlying issue is that your numeric column is being treated as an int column by Tableau, but Redshift doesn't consider them entirely interchangeable.