Date Filter_Filter-In DB

[surekasuraj44]

Hi,

I want to filter the data for date greater than 2020-06-01 using Filter-In DB, however the system is showing and error:

Error: Filter In-DB (7): DataWrapOCI: Unable to prepare the query: "WITH "Tool1_a9b1" AS (select *
from MISRETAIL.CUBE$POSBILLDET@DB_LINK_TO_OLTP) SELECT * FROM "Tool1_a9b1" WHERE "BILLDATE" > 2020-06-01 00:00:00" Error: ORA-00933: SQL command not properly ended.

Request if anyone can help me with the same.

[Thableaus · Accepted solution]

Hi @surekasuraj44 

It seems you're using Oracle, so it's a bit picky on SQL and formats.

The filter you want should work if set this way

"BILLDATE" > TO_DATE('2020-06-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')

Use a Filter In-DB tool and insert this.

Cheers, 

[BenMoss · Accepted solution]

Hi!

As a leader in the Alteryx Community, I have the ability to identify & mark accepted solutions on behalf of community members - and recently did so on this thread. If you have any questions or concerns with the solution(s) I selected please let me know by replying to this post.

Learn more about Accepted Solutions here.

Thank you!

[surekasuraj44]

Hi,

Many thanks for the solution.

[Gooley]

This worked for me with my IN-DB date filter problem as well. Thanks for the simple and clear solution!