Sys Time formats

Yahoo Archive
1
In Epicor 9.05.700B2 on a BAQ (for a Dashboard), you can create a calculated field on the Display tab and use the String() function to convert the Sys Time to 24 hr time (where PartTran.SysTime is an example field from the PartTran table):
String(PartTran.SysTime,"HH:MM:SS")
Hint: The Calculated Field Data Type must be 'Character'

-Rick Bird
IT Software Administrator
Rowmark, LLC.


--- In vantage@yahoogroups.com, "Anon" <jgiese@...> wrote:
>
> Is there a way to get a nice format of the sys time fields found throughout epicor. They all appear to be the current second of the associated day field that accompanies the sys time field, but that doesn't help a lot of our users report/dashboard wise. What things have you folks done?
>
2
Is there a way to get a nice format of the sys time fields found throughout epicor. They all appear to be the current second of the associated day field that accompanies the sys time field, but that doesn't help a lot of our users report/dashboard wise. What things have you folks done?
3
In Crystal, here's a formula. cut and paste the below into a formula
replacing PartTran.SysTime with whichever systime-type field in the db
you're querying. Just FYI, SysTime is seconds since midnight.



// Formula to convert SysTime field

//

Local Numbervar Minute := ({PartTran.systime} mod 3600) / 60;

Local Numbervar Hour := Int ({PartTran.systime} / 3600);

Local Numbervar Second := (Minute mod 60) / 60;

Local StringVar Hr := ToText(Hour);

Local StringVar Min := If Len(ToText (Minute)) = 1 then "0" + ToText(Minute)
else ToText (Minute);

Local StringVar Sec := If Len(ToText (Second)) = 1 then "0" + ToText(Second)
else ToText (Second);

Hr + ":" + Min + ":" + Sec







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Anon
Sent: Wednesday, July 25, 2012 12:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Sys Time formats





Is there a way to get a nice format of the sys time fields found throughout
epicor. They all appear to be the current second of the associated day field
that accompanies the sys time field, but that doesn't help a lot of our
users report/dashboard wise. What things have you folks done?



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2197 / Virus Database: 2437/5154 - Release Date: 07/25/12




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2197 / Virus Database: 2437/5154 - Release Date: 07/25/12

[Non-text portions of this message have been removed]