date difference expression

  • Thread starter Thread starter PJ
  • Start date Start date
P

PJ

I am using the DateDiff expression to obtain the difference between 2
dates.However I can't get it to run.How exactly is it entered into the query
..I am using MS 2002
 
PJ said:
I am using the DateDiff expression to obtain the difference between 2
dates.However I can't get it to run.How exactly is it entered into
the query .I am using MS 2002
Click to expand...

AliasName: DateDiff("x", FirstDateField, SecondDateField)

....where x is the interval you want to count ("d" = days, "h" = hours, etc.).
For more details see the help topic for the DateDiff() function.
 
You must log in or register to reply here.

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

invalid vertical bar 2
#Error 2
Query Parameter 4
Access Access, problem with query. 5
Add to a query Expression! 9
Help with Date Difference Expression 2
date diff expression in query 5
Expression Builder - Arguments 4

Back
Top