SOLVED
error sqlexecute: numeric valuei is not regonized
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Cferrer6
8 - Asteroid
‎08-03-2023
06:46 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
Labels:
- Labels:
- Error Message
1 REPLY 1
Amy_smart
11 - Bolide
‎08-03-2023
07:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
