Help on date issue

building semantic layer
1

Use calander object for selection. A date must be entered.default is current date minus six months-----

Bandreddy :us: (BOB member since 2011-05-04)

2

What’s the question?

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Kinda understood the question.

Having a dynamic default value for date prompts is on a lot of people’s wishlist, but as yet BO does not support this.

dfoster99 :uk: (BOB member since 2010-11-05)

4

I Have a date object in my universe
i need to create a condition using the date object and show the data between Todays date and Todays date - 6 months.
–Orace DB
–Drivers used ODBC

Bandreddy :us: (BOB member since 2011-05-04)

5

A simple way to do this is to create an object that derives ‘today-6month’ and another for ‘today’

You can then reference these objects in your query against the date object (i.e. date object between ‘today-6month’ and ‘today’)

dfoster99 :uk: (BOB member since 2010-11-05)

6

I cannot get the sysdate suing sql in my universe and also not able to use some functions like addmonth()…
i tried this syntax…i know @prompt in the below syntax need to be fixed…but is there anything else you find wrong with this syntax

between (CASE WHEN @Prompt(’Enter the date’,'A’,{’01/01/1900 12:00:00 AM’},mono,free,) = ‘01/01/1900 12:00:00 AM’ THEN trunc(sysdate) – 1 ELSE to_date(@Prompt(’Enter the date’,'D’,object,mono,free,),’MM/DD/YYYY’) END) and add_months((CASE WHEN @Prompt(’Enter the date’,'D’,{’01/01/1900 12:00:00 AM’},mono,free,) = ‘01/01/1900 12:00:00 AM’ THEN trunc(sysdate) – 1 ELSE to_date(@Prompt(’Enter the date’,'D’,Object,mono,free,),’MM/DD/YYYY’) END),-6)

Is this a good approach
my universe screen shot shows the liberty(which i cannot use) with date function attached…

–Oracle db
–ODBC drivers
Web Help.doc (92.0 KB)

Bandreddy :us: (BOB member since 2011-05-04)

7

Build the date objects separately in Designer. The code for these is shown in a “sticky” topic at the start of this forum.

Create an object for TODAY
Create an object for 6 MONTHS AGO

Then in your report, simply drag and drop, so your filter is something like:

WHERE DATE BETWEEN [TODAY] and [6 MONTHS AGO]

Debbie

Debbie :uk: (BOB member since 2005-03-01)