here is the situtation. I have date1,date2,date3 columns in a table. User wants to have one report, where they can choose either start and end date from date1 or date2 or date3. How can I create 3 prompts and give user a choice to select and input only one prompt, Is it possible?
kala (BOB member since 2002-09-26)
Without using VBA this FAQ post would be your only option.
Prompts in Business Objects MUST be filled out.
Andreas 
(BOB member since 2002-06-20)
thanks Andreas…
I was trying this option before. But somehow the date gives me error "not a valid month’ , if I try to convert it to Char. database date has ‘mm/dd/yyy hh:mi:ss am’ format. More over, I will loose the sorting on date. looks like I have no option left…
kala (BOB member since 2002-09-26)
Use a default date of 1/1/1900 etc. (instead of the keyword “ALL”). Then you do not need to convert your date into a char.
Andreas (BOB member since 2002-06-20)