Calculating dates in a query

[Quempel]

Good Afternoon

I am trying to build a query that will give me the number of days that are between the "Completed Date" and the "Requested Date".

I am not familiar with VB or modules. I thought I could just enter: Completed date - request date =

Any help would be much appreciated.

 

[DotNetGnat]

use DateDiff() function

-DNG

 

[Quempel]

So, Would this be correct?

DateDiff([completed date]- [requested dated])

 

[SkipVought]

did you check out HELP for the correct usage and syntax?

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[DotNetGnat]

look here for correct syntax:

http://www.techonthenet.com/access/functions/date/datediff.php

-DNG

 

[PHV]

In the field cell of the query grid:
NumberOfDays: [Completed date] - [request date]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886