I have 2 fields
comm_datetime and comm_todatetime in a table called Communication.
I simply need to work out the difference in hours as a decimal (1.5 being 1 and a half hours) between the two.
comm_datetime in the SQL database is '16/12/2008 16:08:12'
comm_todatetime in the SQL database is '16/12/2008 16:18:22'
I simply need a field called comm_allocated to be set to 10
This needs to work as trigger on insert or update
Many thanks for your suggestions