number of days between dates

[carlisle]

Hi,

I need to work out a couple of calculations, the number of days between an engineer starting and finishing a project, the number of days between the project being put on the database in the first place and being completed by an engineer and finally, the difference between these. These maybe simple, but I have no idea tbh (still new to access).

I have a form with the date it was added onto the database, and the engineer fills in the date started and date finished as it happens.

These run off of 2 tables BookingIntbl and TechnicalServicestbl

[BookingIntbl].[Date], [TechnicalServicestbl].[Date Started] and [TechnicalServicestbl].[Date Finished]

I have then got the fields, 'Days with Engineer', 'Days in Repair Centre' and 'Day Difference' for the answers to be displayed.

Any help would be appreciated, Ben

 

[pbaldy]

You can use the DateDiff function to calculate the differences.

 

[Debased]

Search for UsefulDateFunctions...it is in the Sample Databases at the bottom of page 4 and was created by Pat Hartman and I have found it quite useful though I am not sure in your application it is what you are looking for. But it might give you some ideas.