Skip to Content
0
Former Member
Nov 09, 2011 at 07:25 AM

Date between is not getting filtered...

32 Views

Hi,

I have a WebI report data provider as BI query, where Date format in BI query is as character, but when i put a filter on that to restrict dates between as a prompt in query filters in query panal and refresh the query, It is selecting the dates between the characters but not dates.

Ex: If i choose Dates between Jan2011 to Jun2011, it is sorting all Jan and Jun months in the query and showing results for even 2007 year.

When i tried to change the type in Universe-> obj definition, it is getting parsed, but when i run webi report it is failed.

how to change this to date type in BO/Universe, even i need to filter this in dashboards.

Help would be greatly appreciated.

Thanks,

Raj.