cancel
Showing results for 
Search instead for 
Did you mean: 

Error on Redshift Delete

marilitza
New Contributor

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.

Capture

2 REPLIES 2

mbowen
Employee
Employee

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) + "'"

marilitza
New Contributor

Thanks for the feedback. I will try that.