i have created one date objects based on the user input date which is “TO_DATE(@Variable(‘Enter Effective Date’))” and objects name is “Effective Date”.
and we are using this definition in other filter conditions.
like."@Select(Fund Data Dates\Fund Record Effective Date) <= @Select(Effective Date Objects\Effective Date)
AND @Select(IT - Fund\Fund Next Effective Date) > @Select(Effective Date Objects\Effective Date).
problem occur when i using in the report and passing date value in mm/dd/yyyy format but in bo report its takes dd/mm/yyyy value.so its not work.
First of all, why do you use @Variable instead of @prompt?
Then, do you mean when you use it in the report, it accepts input in one format and displaying the result in some other format? If yes, then is there any formula created for displaying the result? Please post the code.
we are usning @Variable because of some filters are based on the dim dates and some are based on the Quarter end date but prompt name is same like"enter effective date" and by the @Variable we are not creating seprate filters.
Problem is that when i am enter the date value in the prompt in mm/dd/yyyy format it gives error invalid month because of it takes values in dd/mm/yyyy format.
(BOB member since 2007-10-15)