Problem with DateDiff Between Two Fields

[CoolFactor]

Hello,

I have 2 fields one by the name of FirstDay and the other by the name of LastDay and I want to calculate the number of days between the 2 fields using the following expression:

NumberOfDays: DateDiff("d",[FirstDay],[LastDay])

I get the Undefined function "DateDiff" in expression error when I try to execute this query.

 

[lespaul]

sounds like you're missing a reference...i don't know where you need to look but if you search the forum for missing reference you should get some instructions that will help!


Leslie

Have you met Hardy Heron?

 

[CoolFactor]

What Reference do you think it is?

 

[dhookom]

Doug Steele has some information on fixing missing references at Access Reference Problems.

Duane
Hook'D on Access
MS Access MVP

 

[PHV]

Anyway, you don't need any function at all:
NumberOfDays: Int([LastDay]-[FirstDay])

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PHV]

OK, Int is a JetSQL function.
If FirstDay and LastDay doesn't hold time value then:
NumberOfDays: [LastDay]-[FirstDay]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[CoolFactor]

PHV,

How can I get the work days out here?

 

[dhookom]

CoolFactor,
You haven't defined "work days". Have you search google for:
[tt][blue]Access function work days[/blue][/tt]

Duane
Hook'D on Access
MS Access MVP