Hi All,
User has to select Transaction date with time but user can also enter date without time portion. How do I force the user to select date and time and not enter just the date or select just the date from the calendar.
I will like to do two things:
1.Disable calendar
2.Force user to enter date in format mm/dd/yyyy HH:MI:SS AM/PM ALWAYS.
List of values is NOT an option
I am using BO XI 3.1 webi and the database is Oracle 10 g.
ajq
anushajq (BOB member since 2005-02-22)
Not possible without customisation / validation routine built into a custom prompt.
I agree about not using an LOV with dates, however, how is the user supposed to remember the time, down to the second, of the record that they are looking for 
.
Disabling calendar, possible with a universe data type fudge only, see here from Marek:-
https://bobj-board.org/t/135974
Mak 1 
(BOB member since 2005-01-06)
Could you elaborate on what this customization is? We are using Rich Client Xi 3.1.
anushajq (BOB member since 2005-02-22)
Well you would have to build a custom prompt in Java, how easy this is to actually do I have no idea.
A quick Search, give it a try next time ;), yielded this:-
https://bobj-board.org/t/100014
Mak 1 (BOB member since 2005-01-06)