Displaying elapsed number of weeks between two dates

S

SJ

Hi, am trying to run a query to get the number of weeks elapsed between two
dates as follows:

Expr: DateDiff(ww,[Date Started],[Date Submitted])
Clearly this is wrong - can anyone tell me where please!

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested If Statements II 5
Calculate No. Days between two dates 4
Complex query 0
determine number of weeks between 2 date with decimal 1
Difference between two dates 2
Iif statement 9
Calculating weeks 1
Difference between 2 dates 2

Top