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.
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:-
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:-