Invalid syntax after format function

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

Robin Chapple

I have a field [Last Update] and I am attempting to add a literal
instead of a separate label. I am using:

="Last Update " & format(Last Update, "medium date")

and I get the error message Invalid Syntax.

What have I missed. ???

Robin Chapple
 
Try surrounding the field name with [ ] characters:

="Last Update " & format([Last Update], "medium date")
 
Thanks Ken,

That is just what I wanted. I really did think that I had tried that
option. <G> I must get some new specs. <G> <G>

Robin
 
Back
Top