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 .
 

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

Display weeks from a Milestone 0
Countdown macro - display settings 2
Compile error in table level validation expression in ms access office 2019 0
DateDiff function throwing error in Where clause 6
DSum function 4
Iff Function 2
CalcWorkDays error 2
outer join not working 9

Top