Stewart

I was just in the middle of writing out a post when i decided to work out how many miliseconds were in a day. The answer is 86400000. So the code...

Stewart

I just wanted to say thanks for all your help.

At least i can get the system working by adding a day to the end date if the worst comes to the...

Hi, sorry for not getting back to you sooner.

I placed in the following code.....

CREATE TABLE dbo.Test (Param1 DateTime NULL, Param2 DateTime NULL)

INSERT INTO dbo.Test (Param1, Param2) VALUES (01/07/2005, 01/07/2005)

and got...

I'll have to actually head off, but i will have a look into that tomorrow. But how do i go about doing this script.

Thank you for helping me though, i...

I'm trying out this code stewart, but it doesn't seem to add the day onto the end date...

SELECT C.category, C.enquiryDescription, C.resolution, C.startDateTime, C.endDateTime, C.totalDateDiff, C.dateOnlyStart, C.dateOnlyEnd, C.MF_SR_ID

FROM myForms.myUser.CallLogRevenuesBACKUP20050802 C

WHERE...

So just to change my code completely, the working code is now....

SELECT C.category, C.enquiryDescription, C.resolution, C.startDateTime, C.endDateTime, C.totalDateDiff, C.dateOnlyStart, C.dateOnlyEnd, C.MF_SR_ID

FROM myForms.myUser.CallLogRevenuesBACKUP20050802 C

WHERE (C.MF_SR_CTS Between ? And ?)

This requires the...

The only problem i'm noticing now is....

If if put start date = 01/06/2005 and end date as 30/06/2005, then it only includes dates upto the 29/06/2005.

To get the 30th June...

What was strange was i did a ISDATE and some of the values came back as 0's and some 1's.

The data is inserted into the database using an xml package,...

I really can't get any of this to work.

Would it be possible to convert a varchar(50) field to a valid dateTime format.

This is the data that is in the startDateTime...

how do i explain this one.

The fields startDateOnly and endDateOnly fields are varchar, so when i carryout a search it doesn't work properly.  The problem is i cannot change this...

actually i might have to rethink this whole thing altogether.  I have a button search button, when i press it you type the start date in the first pop up...

Sorry was out at lunch

That does help, i'll have a look into it and see if i can work it out

Thanks

Dave

Phil

Thanks for getting back to me.  What you said sounded pretty complicated, but i'll give it a go, should be quite interesting do work out something i've never done before.

If...

The following code worked fine Chris

UPDATE    CallLogRevenuesTEST

SET              dateOnlyEnd = LEFT(endDateTime, 10)

Thanks a lot

Dave

Hey Chris

Thanks for replying.

I think I may have to do it using textfields thought. The data is sent from a system (from a textfield to a varchar) to the SQL Server...