Query with Period Range

[Former Member]

Hi All,

I had written a query for GRPO Register, which is according to my client requirement and is displaying the report correctly.

Now when i run the query it is showing from Books begining from date, where as my client wants to select the period which will be From Date - To Date.

How to assign the Period range so that when the query is executed it will prompt for the date range and allow the user to select and display the result.

Please help me out

Regards

Shanker

[jitin_chawla · Accepted solution]

Hi,

You can refer to the Where and select the conditions in the Query Generator from the relevant table.

Regards,

Jitin

[gagan_thareja · Accepted solution]

Dear Shanker,

Please use the suggestion given by Shridharan. In case this does not help please do let us know.

Regards,

Gagan

[Former Member]

you can use  between [%0] and [%1] in your query wrt date.

For example
SELECT * FROM OPDN T0 WHERE T0.[DocDate]  between [%0] and [%1]