Date Values and the Values list box...

building semantic layer
1

Hello All,

I’m a relative beginner to B.O. so this may be elementary…

I have a date object where the end user is prompted for a value. The date
that they select will be chosen from the list of distinct values taken from
the respective database column by pressing the ‘Values…’ button. The date
object also has a time portion which is displayed in the ‘Values…’ list
box (with AMAM or PMPM?).

Is there a way B.O. can drop the time portion from this generated list? Thus
eliminating all the duplicate dates (due to different times associated with
them)… I’d prefer to avoid adding another column to the base table that
had the truncated value from the original date/time column…

Regards

Ferd

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

2

Set the format for the prompted object over in Designer. It can be found
under the Properties menu option.

Jay

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

3 
 Hi Ferd,

 Follow the procedures:

 1.  Goto the Designer module and open your universe.
 2.  Click on your date column with your right mouse button
 3.  Click on Object properties
 4.  Add date function for your date column (for e.g
      DATE(table1.date1)
 5.  Save your universe and run your query.

 I hope this will help.

 Ravi.

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