No display of today

[#1]

Hi

I have a small problem. Using QV 10,0. I would like to not show today (but every day in the month before today) when opening a report. I know that I can make a trigger when opening the report. And I have already a trigger on month ( = month(today()) ).

I have tried to use the following in a new trigger on day:

=day (before(today()))

=day (not(today()))

=day (<today())

=day (today()-1)

But non of these is giving me a correct result.

If I use = day (today()) then it will show today, but how do I exclude today?

[rahulgupta]

Hi,

You have to use this set analysis in the Expression tab..!!

[gauravkhare]

Hi,

well you already got the solution. You can make of set analysis. Before making use of it you need to declare a variable and that variable will hold the previous date. your approach is going on right direction.

Declare a variable like vYester=DAY(today()-1).

now make use of this varaible in your set analysis expression.

Any more detailed help you want kindly revert.

[Anonymous]

Where do I see or find this calculated dimension?

Go to your Dimension Tab and Click [Add Caculated Dimension]

[#5 · Accepted solution]

Hi all

Now I got the solution. I only use triggers on open report. 3 triggers I need.

First choose: "Select in field" then "Field" = Date and "Search String" = Date(today(),'YYYY-MM-DD')

Second choose: "Select Excluded" then "Field" = Date

Third choose: "Select in field" then "Field" = Month and "Search String" = =month(today())