Error on Redshift Delete

Hello,

Can anybody help me with the following error? I think is the conversion of the snapshot_date field.
The snapshot_date field is of data type date with no time.

Hi Marilitza:

Your date expression is valid (ex: 2021-05-24), but isn’t evaluated in this form. If you click the Equals button, and then build the expression with string concatenation may do the trick. For example,

"snapshot_date = '" + Date.now().toString().substring(0,10) + "'"
1 Like

Thanks for the feedback. I will try that.