Hi,
If you take a datetime-field and make an LOV, how do I make the timestamp-part disappear in the LOV?
It dont help with formatting the datetime-field with “YYMMDD”, in the object properties.
Regards
Christian Herrmann
Sybase Sverige AB, SPS
Listserv Archives (BOB member since 2002-06-25)
Christian,
As a general rule, and due mostly to the user confusion and inconvenience associated with dates/times in date objects I usually do not set up LOV’s for Date objects. This is especially true of fields like transaction date fields. The size of the LOV can get quite large and you gain very little by showing users a huge lists of dates.
I find it is easier to just ask the users to supply the required date values for begin date and end date. You can get users too caught up in using LOV’s for everything.
My humble opinion.
Mike McErlain
Listserv Archives (BOB member since 2002-06-25)
In a message dated 01-05-21 13:54:27 EDT, you write:
If you take a datetime-field and make an LOV, how
do I make the timestamp-part disappear in the LOV?
By default, all date values in BusObj show a time value, whether there is an associated time value in the database or not. The only way that I know of to remove the time is to format the value as a character string, which then means that the sorting is done incorrectly.
It might be nice at some point if BusObj would provide a “date” type and a “date time” type to let us have a little more control over how things like this are handled.
And then there is Mike’s suggestion which I endorse as well… date LOV queries, in general, are not very effective. The LOV file often changes every day (since it is based on a date afterall) and it is easier to simply enter a value as a constant.
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)