'Sysdate' in Condition

building semantic layer
1

Hello all:

Is there an easy way of using ‘SYSDATE’ in a condition as the first parameter in a ‘between’ condition, and prompt for the second date parameter? For example … from today’s date to 10/25/02.

Thanks in advance,
WSH.

Listserv Archives (BOB member since 2002-06-25)

2

Wayne

You could try the following in the condition

where
Test_Date >= sysdate
and Test_Date <= @Prompt(‘Enter to date’)

The above does the same as a “Between”

Minal :slight_smile:

Hello all:

Is there an easy way of using ‘SYSDATE’ in a condition as the first parameter in a ‘between’ condition, and prompt for the second date parameter? For example … from today’s date to 10/25/02.

Thanks in advance,
WSH.

Listserv Archives (BOB member since 2002-06-25)

3

Henry,

The easiest way to do this is to create an object in your universe called “Today’s Date”. Define the object using sysdate and hey presto, away you go.

Regards

Dave

Hello all:

Is there an easy way of using ‘SYSDATE’ in a condition as the first parameter in a ‘between’ condition, and prompt for the second date parameter? For example … from today’s date to 10/25/02.

Thanks in advance,
WSH.

Listserv Archives (BOB member since 2002-06-25)