We help IT Professionals succeed at work.
Get Started

Help with Progress code

Trygve Thayer
on
90 Views
Last Modified: 2017-11-17
I am using a Software called Epicor that uses Progress Open Edge or 4gl.  I am needing to do a rounding function on a number field that stores a "seconds since midnight value.  What I need to do is take that value and convert it to a decimal and then round it up to the nearest quarter hour for clockin and down to the nearest quarter hour for clockout.  What I have found is in the GUI if I take the number field And create a character calculated field I can translate the value to a time.  Here is an example of the code that works
String(Integer(LaborHed.Number01),"HH:MM")  This will give me the military time I am looking for but it is separated by a colon instead of a dot.  So 15:42 is what it may translate to but 15.42 is what I am looking for.  From there I need to take that value and round it up to the nearest quarter hour which would be 15.45 but do not know the syntax to do that.  I also have the ability to just write progress code but too much of a novice to be successful.  Hope anyone can help as manually updating 1500+ employees a day is wearing on me.
Comment
Watch Question
Database Expert
Awarded 2016
Top Expert 2016
Commented:
This problem has been solved!
Unlock 1 Answer and 28 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE