How do I create a filter for today or future dates?

[Enea]

I need to create a filter for date >=today.

What is the syntax I can use?

I am using Webby

Thank you

 

[skrandel]

You trying to do this at the report level or at the universe level?

I don't think there is a way to do this at the report level since "defined" filters do not exist in WebI.

Steve Krandel
VERITAS Software

 

[sh4kil]

You can create a report level variable and then apply a filter on the variable.

e.g. =If([Month (YYYYMM)]>200410;1;0)

I've done a simple IF to look at the month, if greater 200410 then this variable is 1 else 0.

I then filtered the report looking for 1's.

 

[tommyboyau]

Enea:
In my experience the best way to do this is add a Predefined Condition to the universe. You will need to speak to your universe designer about this (unless that is you!)
Here are some examples of predefined conditions I have used in the past:
This is relevant for Oracle 9i Datawarehouse:

Create a predefined condition like below:
Last 28 Days:

 @select(DATE DIMENSION) BETWEEN (sysdate-28)  AND sysdate

Next28 Days:

 @select(DATE DIMENSION) BETWEEN sysdate  AND (sysdate+28)

Today and tomorrow:

 @select(DATE DIMENSION) BETWEEN sysdate  AND (sysdate+1)

Just Tommorow:

 @select(DATE DIMENSION) = (sysdate +1)