datediff function compile error

M

Michael Whitney

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]
 
M

Michael Whitney

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

Marshall Barton

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