[mil1234]

Hi to all,

i have 3 columns 1) StartDate, 2) EndDate and 3) TotalHours . I want to put a function in computed column specification of TotalHours so that when the StarDate and EndDate are inserted the hours are subtracted and the total hours is automatically filled up. I was triying with this but the total hours property is still getting null:

(datediff(hour,[StartDate],[EndDate]))

Any ideas??

Thanks....

[Vishu Sukhdev]

Hi,
This will help you

  DATEDIFF(hh, StartDate, EndDate) AS TotalHours   

[baavgai]

You're using the correct function.
e.g. This will get you 24:

select datediff(hour, GetDate()-1, GetDate())

However, this will get you null:

select datediff(hour, GetDate()-1, null)

Both values must be dates and not null for the function to do it's thing.

Note, hour and hh are the same.