Audit Report-Date Conversion

[former_member334960]

Hi All,

I am working on creating an Audit Report using WEBI 4.1.

I am using the object "Event DateStamp" as a filter in the Webi report where the user is prompted to select a date range.(I have used Between function)

I have come across a problem with the datatype of the object "Event DateStamp".

The default datatype of the Event DateStamp object in the universe i installed is String. I changed that to Date and also changed the syntax to

" CAST(ADS_EVENT.Start_Time AS date "

But the above gives me an error.

I also tried with a different syntax as  -" convert(varchar(10),ADS_EVENT.Start_Time,101) "

But none of the above worked for me..

I need to allow the user to select date range when they run the report in WEBI.

Could some one provide your suggestions on this?

Thank you.

[former_member334960]

Another option I see here is to use the existing objects - "Event DayOfMonth"(which gives day) , "Event MonthNumber" (which gives month number) , "Event Year" (which gives year) to create a new Date dimension and allow the user to select from this.

Could anyone please let me know how this can be achieved?