Forum Discussion

marilitza's avatar
marilitza
New Contributor
5 years ago

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.

General Information
pipeline

2 Replies

  • mbowen's avatar
    mbowen
    Employee
    5 years ago

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