DateTime issue in WEBI Query

[Former Member]

Dear All.

i have created a simple universe and in which there is one column of type DATETIME i created one Dimension object of Type DATE for that column.

I want to get all the data from the table by giving datetime criteria i.e. for one day its start form 10:00 PM to morning 10:00 AM.

for example if i want to get the data of 1st June i have to give the criteria in the filter.

01/06/2011 10:00:00 PM to 02/06/2011 10:00:00 AM OR

01/06/2011 22:00:00 to 02/06/2011 10:00:00

I try to pass these both format in the filter but it get no data and when i pass only the dates i get the data.

Can any body please let me know that how to pass the datetime so i can get the data base on datetime.

[former_member207342]

Check the format of dates passed through Prompt and date format of column.

--Kuldeep

[Former Member]

i have set the Object Format and under Object Properties Database format as 'mm/dd/yyyy hh:mm:ss' in the Universe Designer.

and i am passing the following values in the prompt under WEBI.

FROM 5/30/2011 10:00:00 PM

TO 5/31/2011 10:00:00 AM

but it returns me values starting from 5/30/2011 10:00 AM when i check in WEBI the SQL its only send 10:00:00 without AM and PM.

Kindly please let me know how it will work.

Kind regards,

Edited by: Syed Zeeshan Haider on Jun 2, 2011 10:57 PM

[amitrathi239]

Hi,

Which database you are using and what is the date format in the table column.

one more thing if you add prompt in the webi query and check the LOV then date format is coming as you set in the database.

Thanks,

Amit