Skip to Content
avatar image
Former Member

How to get Time from date Object.


Hello everyone

I have a date stamp objects on which , I am getting value like :

01/05/2015 22:15

06/04/2015 16:24

My requirement is to filter the webi Report on the basis of two parameter like :

Enter the date  & Enter the Time

For Example : if i enter date 12/10/2015 and time is : 09 then only thouse records will come which are existing on this selection criteria.

But i have only onedate stamp objects which haveing both date & Time value .

So Please suggest me how i can filter my records based on two parameter , from universe or from webi and solution will work for me.

I am using BO 3.1.

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 14, 2015 at 01:02 PM

    I my view you would be better off doing this in the universe rather than at the WebI report level. The reason being that to do it in WebI you would not be able use a query filter. So you would have to bring back more data than necessary and then apply a report filter.

    You didn't mention what type of database your universe is based upon. I am most familiar with SQL Server so I am going to use that in my explanation. If you are using a different database you will have to adjust the syntax accordingly.

    You could you use the CONVERT function and specify whatever "style" you prefer to get the date and time separate.

    CAST and CONVERT (Transact-SQL)

    It should be noted that these are now strings. So if you have a prompt for the date in WebI you will not be presented with a calendar to choose it.

    You could convert back to a DATE or even DATETIME like this and then you will have the appropriate datatype such that you will get a calendar with your prompt.

    I don't remember the exact situation, but I have had trouble with the DATE datatype. So I have always just stuck with DATETIME.

    Hope this helps you out.

    Noel

    Add comment
    10|10000 characters needed characters exceeded