decimal places

[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

 

[Guest]

Hi Patrick - for hours you should be using the Date/Time Field type, not
Number. Then enter as 1.50. Hope this helps.

 

[Joseph Meehan]

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

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.

 

[Douglas J Steele]

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).

 

[Douglas J Steele]

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.

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.

 

[Joseph Meehan]

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.

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.