date calculations 1

[NeedToKnow2]

Hi All,

I am new to Access. I have learnt some basics on queries, etc. and can do some simple SQL. I would like to know how to get a calculation between 2 dates in 2 different fields. One field is called "ACTION_DT" (date field) and the other is "PH_END_DT" (date field). The first field is the start of a phase and the other is the end. I need to know how much time is in between. I would also like to know how much time between phases. I appreciate any help you can give me in this matter and I apologise for my ignorance.

Thankyou!

 

[Golom]

You can use the DateDiff function to create a field in your SQL statement like this

Select ..., DateDiff("d",ACTION_DT, PH_END_DT) As [DaysElapsed], ...

 

[NeedToKnow2]

Hi Golom,

Your a genius! It works like a charm. I really appreciate your help.

Thankyou!

 

[lespaul]

Wow Golom, a genius! Have a genius star on me!!

Leslie