cancel
Showing results for 
Search instead for 
Did you mean: 

Time in USR5

Former Member
0 Kudos

Dear Expert,

There is a field in USR5 table 'Time'. I want to show this field in report. How can I show that in AM/PM format.

Plz reply.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Amit ,

Use This Formula

numbervar ntt := {Command.Time};

stringvar nttx := totext(ntt,"0000");

time(val(left(nttx,2)),val(mid(nttx,3,2)),val(right(nttx,0)))

Regards

Bhanu

former_member188586
Active Contributor
0 Kudos

hi

what is your B1 Version?

Former Member
0 Kudos

Hi,

I am using B1 9.0 PL-07

Regadrs