Change Column Format Time to HH:MM:SS

tomdomurat · March 30, 2017, 4:08pm

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

Kimberley · September 25, 2018, 5:49pm

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

thanks Kim

dhewi · September 25, 2018, 6:29pm

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.

mhelfrey · September 25, 2018, 6:37pm

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

Kimberley · September 25, 2018, 7:00pm

That would be great. Thanks

tfenwick11 · September 25, 2018, 7:19pm

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

mhelfrey · September 25, 2018, 7:20pm

Dashboard and BAQ Export is attached. v10.2.200.6

PartTransactionTracker.dbd (384.7 KB)

Chris_Conn · September 25, 2018, 7:31pm

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