Time and Date Problem

[davedynamic]

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.

 

[Pat Hartman]

Is your estimated time really entered in minutes or did you convert it?. You can use the DateAdd() function to add minutes to a date and return a date.

DateAdd("n",EstMin,YourDate)