davedynamic
10-03-2001, 11:46 PM
I have a field called Start Date which store the start date for a job.
I have a field called estimated time. The time we guess a job should take.
I am trying to write a query to add the time to the date to ascertain the next available date.
My time is in minutes. I convert this to hours first. However, this gives numbers like 1.86663. When I add this to the date it gives me a numeric value.
I think what I need to do is parse the whole numbers and turn the balance into hours and minutes again. However, I do not know how to do this.
I have a field called estimated time. The time we guess a job should take.
I am trying to write a query to add the time to the date to ascertain the next available date.
My time is in minutes. I convert this to hours first. However, this gives numbers like 1.86663. When I add this to the date it gives me a numeric value.
I think what I need to do is parse the whole numbers and turn the balance into hours and minutes again. However, I do not know how to do this.