Specifying query datatype

[kdm3]

Hi all,

I have a problem which needs resolving, I have a query which is used to calculate the number of days to complete a task, based on the time it should take in mins - i.e. if it takes 5 mins, you still need to set aside a day to peform the task. I thought of setting the datatype as integer, but don't know how to this.

 

[Mile-O]

I have a query which is used to calculate the number of days to complete a task, based on the time it should take in mins - i.e. if it takes 5 mins, you still need to set aside a day to peform the task.

Okay, but you don't say anything about your structure - there's nothing that can help from what's been said. Is this based on present fields? Is it a calculation? Is there other logic than less than 24 hours equals one day?

I thought of setting the datatype as integer, but don't know how to this.

What datatype?

 

[kdm3]

OK, the source reference time is calculated by multiplying the quantity required (unknown datatype from query, probably long) by the est process time (long) and adding the est setup time (again long), all from other tables and queries.
This generates an estimate of the time required to perform the operation, in mins, I want to use this value to calculate the number of days required for the op. I used a pretty crude divide mins by 420 - a working day - but this generates a decimal answer, I just want a whole number.

Any ideas?