tomdomurat
(Thomas Domurat)
March 30, 2017, 4:08pm
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
Kimberley
(K White)
September 25, 2018, 5:49pm
2
Did you ever find an answer to this? I want to fix the time in Part Transaction History.
thanks Kim
dhewi
(Daryl Hewison)
September 25, 2018, 6:29pm
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.
2 Likes
mhelfrey
(Matt Helfrey)
September 25, 2018, 6:37pm
4
Or, make your own Part Transaction History Dashboard. I’d be willing to share if your interested.
1 Like
Kimberley
(K White)
September 25, 2018, 7:00pm
5
That would be great. Thanks
tfenwick11
(tyler fenwick)
September 25, 2018, 7:19pm
6
@mhelfrey could you send me the dashboard and query please.
mhelfrey
(Matt Helfrey)
September 25, 2018, 7:20pm
7
Dashboard and BAQ Export is attached. v10.2.200.6
PartTransactionTracker.dbd (384.7 KB)
4 Likes
Chris_Conn
(Chris Conn)
September 25, 2018, 7:31pm
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
1 Like