Query with variable and restriction

[Former Member]

Dear All

I want obtain limited list.

Example,when I use in query

set @DataFrom = (select min(T3.TaxDate) from dbo.OJDT T3 where T3.TaxDate >= '[%2]')

I can choose data from firt to last Journal Entry.

What can I do when I what show data only from 2009 year?

Thanks in advance

Tom

[Former Member · Accepted solution]

Thanks for all response.

I think that I didn't explain enough my problem.

When I have a code in query

set @DataFrom = (select min(T3.TaxDate) from dbo.OJDT T3 where T3.TaxDate >= '%2')

after launch a query appear a window where I can write date or I can choose date from list.

I need in this list only date from 2009 year.

Tom

[Former Member · Accepted solution]

That is not possible.

[Former Member]

What a pity!

Thanks for answer.

Tom

[Former Member]

Dear Tom,

How about use Year(T3.TaxDate) = 2009 directly in your query? You don't need start date and end date for this condition.

Thanks,

Gordon

[Former Member]

Hello

I am suggest to use FInancial Period from / To instead of booking dates, if it is possible. I mean if you need month end closing dates, it would work fine.

If you need dates, why are you using list, not dates as parameters?

Regards

János