Steve,

Thanks for your reply. Client & the server are different machines. Its already in TCP/IP.

Drew,

I tried your query, but it throws an error message. Incorrect syntax near 'DateADD'.

Thanks to all for your valuable inputs.

I am sorry about the table format which i posted earlier.

Just an example i am posting it again

ReadingDate ...