datediff function compile error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am getting a compile error with the following function in a query.

dtdiff: DateDiff("d",[Query Name]![Date Field Name1],[Query Name]![Date
Field Name2]
 
Typo

Jerry Whittle said:
Unless what you posted it a typo, your missing the final )
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


Michael Whitney said:
I am getting a compile error with the following function in a query.

dtdiff: DateDiff("d",[Query Name]![Date Field Name1],[Query Name]![Date
Field Name2]
Click to expand...
Click to expand...
 
Michael said:
I am getting a compile error with the following function in a query.

dtdiff: DateDiff("d",[Query Name]![Date Field Name1],[Query Name]![Date
Field Name2]
Click to expand...


The ! should be .
 
Back
Top