Format () question

  • Thread starter Thread starter Laurel
  • Start date Start date
L

Laurel

I'm trying to get a date to display in this fashion:
Wednesday, Nov 14 (or Wednesday, November 14 if I must).

If I use this format "dddddd\,mmm dd" I get this strange result:

Wednesday, November 14,2007,Nov 14

If I use this format "ddddd\,mmm dd" (dropping one 'd'), I get this result:

11/14/2007,Nov 14

Very strange. Is there a way to get what I want with the Format(,)
function?
 
Or, if you're using the Format property of a textbox in the report:

dddd, mmm dd
 
You should leave the control source with just the date field and set the
format property to
dddd, mmm d
 
Back
Top