Thats great thank you, the computed columns idea seems like a nice way to keep it all stored and easily accessable.

Thank you Frank, I hadn't realised that about the time part of it. I was just entering the date.

I've got it sorted now though I think

I was using:

SELECT * FROM...