Rather than hitting yor head off a brick wall for a day, why don’t you try using the search
Here are two to get you started…
I have a universe that is used to track Issue Tickets for ATMs. I have a few data objects (Date/Time Ticket Open) and (Date/Time Ticket Closed). Both of these reference fields in a DB2 database and are stored as timestamp.
Here is my issue, my users like to query off both of these fields. However, they can only do so if they enter a criteria as a constant, if they tried a prompt they get the following error.
Bottom line - my user would like to enter a date 05/10/2006 in a prompt and see the re…
Hi All,
My @prompt is something like :
@prompt(‘txt’,‘D’,‘class/object’,mono,free)
In infoView (XI rel.2 on oracle db) I see my lov as
01/06/2006 00:00:00
02/06/2006 00:00:00
and so on…
I don’t want to view these 00:00:00 (as a timestamp format). I could use a to_char, but I’d like my query using dates. Any idea?
andreo74
dessa (BOB member since 2004-01-29)
(BOB member since 2004-01-29)