I am not sure how to ask this and was not real successful searching for the answer since I didn’t know how to ask the question
I have a report that the user want to run by different date criteria. For example, one department want to see all ‘orders’ delivered where order_date = today, another department wants to see all ‘orders’ delivered where the delivery_date = today, and so on…
The only thing that changes is the date column of the where x_date=today.
I would like the user to be able to select the date condition from a drop-down…
A pre-defined condition (a universe object) as follows would do the trick. The syntax assumes Oracle:
(@prompt('Choose date type','A',{'Delivery date','Order date'},mono,constrained) = 'Delivery date'
AND tbl.delivery_date = trunc(SYSDATE)) OR
(@prompt('Choose date type','A',{'Delivery date','Order date'},mono,constrained) = 'Order date'
AND tbl.order_date = trunc(SYSDATE))
Thanks Duane… Don’t know why I had such a mental block on this… I am using Teradata, but will adapt accordingly if possible… Teradata gets a little funny on some stuff and just will not work with Business Objects
larry
We’ve been using Teradata with BO for years; the one date-related gotcha that comes to mind is mistaking TIMESTAMP and DATE data types for each other. Once you know the actual datatype, you can manipulate the data accordingly. Like this, for example.
(BOB member since 2002-09-19)
(BOB member since 2002-09-19)