Change Column Format Time to HH:MM:SS

I want to change the Column Format from INT to HH:MM:SS. The field is [OrigTime] which is an integer value.

I tried changing the Grid Collection Properties > Format and also the Extended Properties of the DataView column.

The end result in both cases shows “HH:MM:SS” in the displayed results

Did you ever find an answer to this? I want to fix the time in Part Transaction History.

thanks Kim

My understanding is that you can’t make Epicor’s time fields display as a time because they’re actually integers.

If you want a time then the easiest way is to add the time field value in seconds to the relevant date field and then format the result. We’ve added a datetime UD field to our PartTran table to get round the problem in Part Transaction History Tracker, and a BPM keeps it in sync with Epicor’s fields.

2 Likes

Or, make your own Part Transaction History Dashboard. I’d be willing to share if your interested.

1 Like

That would be great. Thanks

@mhelfrey could you send me the dashboard and query please.

Dashboard and BAQ Export is attached. v10.2.200.6

PartTransactionTracker.dbd (384.7 KB)

4 Likes

I believe the time is seconds since midnight.

DateTime.Now.Date.AddSeconds(your time in s).ToShortTimeString();

//or sql if you are doing a Calculated Column

1 Like