How do I format the date field within a concatenated control?

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

Guest

I want to include a date control within a concatination., eg. =trim("the date
of approbal was "&[date]) and want to have it formated as dd,mmm,yyyy. That
is the way it is in the table but it formats in the report as mm/dd/yyyy.
 
="the date of approval was " & Format([SomeDate],"dd,mmm,yyyy")

Something like that. you can look up "FORMAT" in help if that syntax is not
exactly correct.

Also, I think replacing the & with a + will cause the string to print only
if a dat exists. Not sure if that is important to you.
 
Back
Top