error sqlexecute: numeric valuei is not regonized

[Cferrer6]

hello, 

i have my flow connected to snowflake. i create a column to give me the month and year(yyy-mm) from an existing field that had yyy-mm-dd format . i then tired to filter out a specific month (example 2023-05) but it gives be this error (using in database tools)

any ideas why its throwing that error?

[Amy_smart · Accepted solution]

Hi,

You could use a filter and then choose [date]does not contain '05' month.

Numeric values usually do not have 0's before the numbers.

Thanks,

Amy