Display TIME in BEx query

[Former Member]

Hello Guys,

I have time field in my query ( Arrival Time : 13:00:00).

but when i run the query, its displaying as only '1' instead of 13:00:00.

Could please tell me, how to display the actual value in the field in the report.

thanks,

BI Consultant

[former_member188325]

can you just try out by creating new formula TIME(KF).

TIME (process value as time) function is available under data functions of fomrula builder.

if your InfoObject is characteristics,create a formula variable on it use TIME function.

Message was edited by:

Murali

[Former Member]

Hello Murali,

Thanks very much for your reply.

its displaying ok , when i have the time value.

Its not displaying anything if the time is 00:00:00.

Could you please help me how to display the above value.

thanks

BI Consultant