Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Date Filter

Hi All,

I have a dimension "Completed Date", data type Date, its SQL:


I created a filter for it with the formula, called it MyCode to indicate below:

@Select(path\Completed Date) LIKE @Prompt('Completed Date','D','path\Completed Date',Mono,Free,Not_Persistent,{'ALL'}) OR 'ALL' IN @Prompt('Completed Date','D','path\Completed Date',Mono,Free,Not_Persistent,{'ALL'})

when i validate the formula, I got the error "ORA-00920: invalid relational operator". I do not configure out the reason why.

Moreover, I would like to enhance the filter with the requirement:"Select “ALL” by default and prompt user to select between Completion Start Date and Completion End Date from the list of values". I think I should use BETWEEN ... AND.

@Select(path\Completed Date) BETWEEN MyCodeForStartDate AND MyCodeForEndDate

I wonder if it has any problem.

Help me please! Any suggestion would be appreciated.

Thanks in advance!

Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question