Ok, I have implemented a self join that looks like the following
@Prompt('Select Date',,'class\date_id',mono,free) between a.open_id and a.close_idThe date id’s are stored as numbers. For example 2/3/2009 is stored as 20090203
What I want is to have a LOV display a date format but when selected it will actually be the number format on the backend to fill the prompt.
Has anybody done this before?
mwooldri 
(BOB member since 2002-07-10)
Wrap @Prompt(‘Select Date’… around to_num(or its equivalent, I dont know what database you are on!) to convert it into number. Please note that the User response of EVEN A DATE PROMPT is of CHARACTER DATATYPE.
nithya_raj (BOB member since 2007-02-03)
Yes, I already tried that and I still get an invailid number.
mwooldri (BOB member since 2002-07-10)
Could you post your code WITH the conversion done? That will help to analyse better.
nithya_raj (BOB member since 2007-02-03)