Is there a way to NOT display the time portion when a date object is selected under the conditions box?
Currently this is what what we see in the conditions box :
Anniversary date greater than 1/1/1998 12:00:00 am
Is there a way to change it to only display:
Anniversary date greater than 1/1/1998
Thanks,
Edna
Listserv Archives (BOB member since 2002-06-25)
Sent: 24. heinkuuta 1998 16:07
Is there a way to NOT display the time portion when a date object is selected under the conditions box?
Edna,
you can strip the time portion from the object, for example with Oracle, define the Anniversary’s SELECT clause as: to_char(Table1.AnnDate,‘m/d/yyyy’)
Now, this solution is database-dependent and may not serve your business need. But it works for the most of the cases.
Cheers,
-Harri
Thanks,
Edna
Listserv Archives (BOB member since 2002-06-25)
-Reply
I am sorry, but I was probably not clear on the problem…so here it is another try.
My concern is not in NOT displaying the time portion in my report (after it ran), but in the QUERY PANEL.
It is when a user is still selecting the results objects and putting conditions. If a date is chosen in the CONDITIONS part of the QUERY PANEL, and we type a constant for the date, it will automatically display date and time, always a time of 12:00:00 am(eg. ANNIVERSARY DATE GREATER THAN 1/1/1990 12:00:00 am) This is not interfering retrieval of information or with the SQL, which is correctly displaying the date portion only.
Is there a way to just display in the QUERY PANEL under the CONDITIONS window a date without the time portion?
Thanks,
Edna
Listserv Archives (BOB member since 2002-06-25)
In a message dated 98-07-24 11:32:18 EDT, you write:
My concern is not in NOT displaying the time portion in my report (after it
ran), but in the QUERY PANEL.
It is when a user is still selecting the results objects and putting conditions. If a date is chosen in the CONDITIONS part of the QUERY PANEL, and we type a constant for the date, it will automatically display date and time, always a time of 12:00:00 am(eg. ANNIVERSARY DATE GREATER THAN 1/1/1990 12:00:00 am) This is not interfering retrieval of information or with the SQL, which is correctly displaying the date portion only.
Is there a way to just display in the QUERY PANEL under the CONDITIONS window a date without the time portion?
Hi, Edna.
As you have noted, there is no problem with the time being there on the query. In fact, if you look at the SQL being generated, it may be that no time element is being used at all in the code!
On a hunch, I tried removing the “Time” format from the Regional Settings in the Windows control panel. (The default BusObj date format is based on those settings.) I thought that if there were no default time format then perhaps BusObj would not display the time along with the date… unfortunately, Windows does not like leaving the setting blank. When I changed it to just “H” for hours then my Windows clock was affected, but BusObj still displayed the full time. Oh well, nice try.
I don’t know of any way to turn that “feature” off. Perhaps you can inform your users that it doesn’t matter and let it go at that.
Regards,
Dave Rathbun
Integra Solutions
www.islink.com See you in Orlando in '98!
Listserv Archives (BOB member since 2002-06-25)
-Reply
Edna, this is a shot in the dark but have you tried manipulating the format of the object itself in the designer module? Another painful lesson I have learned is that you should instruct your users NOT to type a constant like date cause chances are there will be some sort of error in the format they type. This leads to support calls because the query will return no rows if incorrectly typed.
Edna Lee wrote:
I am sorry, but I was probably not clear on the problem…so here it is another try.
excerpt…
Is there a way to just display in the QUERY PANEL under the CONDITIONS window a date without the time portion?
Thanks,
Edna
Listserv Archives (BOB member since 2002-06-25)