Using in_range in native sql

[yildirim.arda]

Hello,

I need to use native sql syntax in my report and I have a date range prompt in the prompt page.
As I am using native sql, I can't use in_range function in the sql.
How can I solve this issue? How can I use these two dates in my native sql?

Thanks.

[BigChris]

Assuming you really do need to use SQL and bypass all the security of the FM model, I think you'll need to create two date prompts, ?BeginDate? and ?EndDate?, and use those in your SQL

[MFGF]

Why do you need to use native SQL? What problem do you have that can't be solved in your framework model?

MF.