invalid vertical bar

I receive a message that "The expression you entered has invalid vertical
bars(|). I am just modifying an existing query when I get this error
message. I have tried to use commas instead but I get a different error.
You omitted an operand or operator, you entered an invalid character or
comma, or you entered text without surrounding it in quotation marks.
This is the query field that I am trying to modify.
Days Old: DateDiff("d"|[Corporate Received Date]|[Today's Date])

Thanks for your Help.

Try:
datediff("d",[firstfield],[secondfield])
--
Milton Purdy
ACCESS
State of Arkansas


"WuiChi" wrote:

I receive a message that "The expression you entered has invalid vertical
bars(|). I am just modifying an existing query when I get this error
message. I have tried to use commas instead but I get a different error.
You omitted an operand or operator, you entered an invalid character or
comma, or you entered text without surrounding it in quotation marks.
This is the query field that I am trying to modify.
Days Old: DateDiff("d"|[Corporate Received Date]|[Today's Date])

Thanks for your Help.

The most commons separator characters are commas (,) or semi-colons (.
Unless your computer is set to use some other character as the delimiter I
would try those.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

golfinray wrote:
Try:
datediff("d",[firstfield],[secondfield])