Date Expression Error

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

Guest

I am using Micrsoft Access 2007 and i get the error when i generate the report.
A pop up message saying "Function is not available in expressions in query
expression 'format(nz(min(TLO_Date),"7/16/2007"),"dd/mm/yyyy"' is displayed.
Proceeding further by clicking OK multiple times, report will be displayed.
But the dates are displayed wrongly in this report.

Can somebody advise on that? Many Thanks.
 
I am using Micrsoft Access 2007 and i get the error when i generate the report.
A pop up message saying "Function is not available in expressions in query
expression 'format(nz(min(TLO_Date),"7/16/2007"),"dd/mm/yyyy"' is displayed.
Proceeding further by clicking OK multiple times, report will be displayed.
But the dates are displayed wrongly in this report.

Can somebody advise on that? Many Thanks.
Click to expand...

For one thing, a date literal should be delimited by # rather than "; for a
second, you don't have a closing parenthesis for the Format function.

I'd suggest just applying a dd/mm/yyyy Format property to the textbox itself,
and set its control source to

=NZ(Min([TLO_Date]), #7/16/2007#)

Not sure about the Min, that's going to depend on the context of the rest of
your query!

John W. Vinson [MVP]
 
Back
Top