Pull records that started and finished on the same day?

There are two different fields that are included in a database, one is Actual Start Date, the other is Actual Finish Date.

The field includes a time and date such as
2006-09-07 10:03:45.060

Is there a way to set it up so that it only pulls records that have an Actual Start and Actual Finsih time that are on the same day? I know the time is included, but I want to disregard time in the query.

I would figure I could somehow setup the query like this, I'm not sure how though, since I want it to only look at the day.

Thanks,

~J

This can certainly be done..
what or where do you want to put these records?
eg:
Do you just want to hide the rows that are don't match?

Here is a macro that will hide rows that don't have mathching dates..

Please Login or Register  to view this content.

I think I worded it wrong. I really only have to base it on the Actual Duration column, which is the column that I have setup in the format d-h:mm

I just need it to go through every record and only show the records that have a 0 as the d. I just need it to delete the rest.

Would the code still do that?

Sorry about that and thanks!

~J

which column is you duration?

This is assuming you durations is in col b rows 2-40..you can change this as needed.

Please Login or Register  to view this content.

Duration is in the 'E' Column. The data in that column actually starts in E4

The first column with Data in it is column C and there are columns all the way till column N. The data starts on the 4th row.

Thanks again for helping me!

~J

This will look at column E for rows 4 to 400 ( change the 400 in you like.. in line For i = 4 To 400 ...it delete the eniter row if not there is duration is not 0 days

Please Login or Register  to view this content.