End date prompt in a different format!

[funkmonsteruk]

The most bizarre thing has happened to me, I've got a condition that uses a between query prompt at report level. The date is formated at universe level as dd/mm/yyyy, the start date prompt i have added works fine i enter a date using dd/mm/yyyy format and averything is ok, however the end date (this is from the same object) requires me to enter the date in a mm/dd/yyyy format -

The query prompts are display within the report and i don't seem to be able to format the display of the dates in these either, anybody come across anything like this before?

 

[skrandel]

Rather than using between use 2 prompts with an OR. What happens then. It's possible you've found a problem with the between logic.

Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com

skrandel@baseconsulting.com

 

[funkmonsteruk]

That seems to work fine Steve.... Cheers for the pointer!!! Have you come accross anything like this before?

 

[skrandel]

Not ever seen ths before. Make sure BO logs this as an issue.

Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com

skrandel@baseconsulting.com