Change Column Format Time to HH:MM:SS

Epicor ERP 10
1

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

SetExProp.jpg930×301 101 KB
ColumnFormat.jpg895×481 104 KB

2

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

thanks Kim

3

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.

4

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

image
image.png918×789 46.4 KB

5

That would be great. Thanks

6

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

7

Dashboard and BAQ Export is attached. v10.2.200.6

PartTransactionTracker.dbd (384.7 KB)

8

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