decimal places

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set 2 decimal places for a number field (hours) but if I enter 1.5 or
1.50 it rounds up to 2.00
 
Hi Patrick - for hours you should be using the Date/Time Field type, not
Number. Then enter as 1.50. Hope this helps.
 
Patrick said:
I have set 2 decimal places for a number field (hours) but if I enter
1.5 or
1.50 it rounds up to 2.00
Click to expand...

Two guesses:

You are using an integer number type. Integers are . . . well they are
integers (whole numbers no decimals.) You need a to use a single or double
number type.

I suggest you may want to use a time-date type if you are trying to work
with times. The Date type is really for date and time.
 
No, you shouldn't use a Date/Time field for hours.

Date/Time fields are intended for timestamps: specific points in time (a
date and time both).
 
Joseph Meehan said:
Two guesses:

You are using an integer number type. Integers are . . . well they are
integers (whole numbers no decimals.) You need a to use a single or double
number type.

I suggest you may want to use a time-date type if you are trying to work
with times. The Date type is really for date and time.
Click to expand...

If all that's being stored is hours (presumably as a duration), then a
Date/Time field is not appropriate. It's intended to store a timestamp.
 
Douglas J Steele said:
If all that's being stored is hours (presumably as a duration), then a
Date/Time field is not appropriate. It's intended to store a timestamp.
Click to expand...

I agree. I am not sure exactly what the OP is doing, which is why I
suggested that they "may want to use" It may have sounded like should
however.
 
Back
Top