Access97 calculate how many days fall between two dates 1

[Roal]

Hi,

I am trying to find out how many days fall between two dates stored in a table so that I can show on a report whether deadlines have been met.

I.e DateReceived and DateReplySent.

I need to look these dates up from a table (tblCorrespondence), in order to generate a report and was hoping to use a Look Up Query as the Record Source.
Being unfamiliar with Access97 it has been giving me a few problems and I was wondering if any one could suggest a simple way of achieving this.

Thanks in advance
Roal

 

[Junior1544]

look up DateDiff

see if that will help you...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[Roal]

Thanks,

I've tried using DateDiff, but I'm not sure how I can get it to look up dates in a table rather than prompting the user to enter a date.

Other than that it worked fine...

Roal

 

[Nevets]

Try this:
DateDiff("d",[DateField1],[DateField2])

 

[Roal]

Thanks Nevets,

Thought that was the formula I wanted, but wasn't sure.

Re-checked and turns out I had made a typo on one of the fields. (school boy error)

Thanks again,
Roal