decimal places

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
 
G

Guest

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

Joseph Meehan

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

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

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

Douglas J Steele

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.

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

Joseph Meehan

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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top