date difference expression

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
 
R

Rick Brandt

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.
 
Top