cancel
Showing results for 
Search instead for 
Did you mean: 

Display TIME in BEx query

Former Member
0 Kudos
187

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member188325
Active Contributor
0 Kudos

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
0 Kudos

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