Hi all urgent issue

[krishdw85]

Based on the current month ...my report should produce only that month report...can i have the solution pls


One more for this current report only last 15 days from the current date???

[gshilpa24]

Can u please elaborate ? Are you using the prompts and what data do u have?

[krishdw85]

Hi.....having relational DB.

i have to keep a filter condition ......hardcoded
that should run based on the current system month.

for ex system date........in the yyyymmdd format

what should i mention in the filter condition.....

thx for ur post

[technomorph]

This is still a bit vague.

Maybe this is what you're looking for:

[Date] between _first_of_month (current_date) and _last_of_month (current_date)

[krishdw85]

Whenever the user runs the report ........i need a particular current year with the current month data.
EX:Sep 28 2010 if this is a system date i need the information in my report should be sep 2010 report.

I need a hardcoded filter or if not prompt is possible??

thanx for ur patience ........

[kattaviz]

Hi,

What is the DB column u r filtering on?.

Example:

If you are filtering on Year and Month, you can extract Year and Month from system date and pass the same to your query. Something like ([YEAR]=year(current_date) and [MONTH]=month(current_date)).

HTH

[cognostechie]

Whenever the user runs the report ........i need a particular current year with the current month data.
EX:Sep 28 2010 if this is a system date i need the information in my report should be sep 2010 report.

I need a hardcoded filter or if not prompt is possible??

thanx for ur patience ........

I don't know what is the name of your Date field so presuming you Date field name is - 'TR_DATE', try this in the filter condition:

cast(extract(year,TR_DATE),integer) = cast(extract(year,current_date),integer) and
cast(extract(month,TR_DATE),integer) = cast(extract(month,current_date),integer)

Though there is no need to convert the result of an extract function to integer but I don't know what format your TR_DATE is in so just being safe.

Next time your post is not clear and I see that you did not make your efforts in being clear and posted just a verbese language, I will definately not reply.