how to format a date

• antonio.collins

  SSCrazy Eights

  Points: 9600

  More actions

  August 1, 2008 at 9:45 am

  #190341

  My report needs a single field which concatenates several fields. The fields are a date and two other text fields. The result should be as

  08/01/08, Friday: some text

  "MM/dd/yy, dddd" is the proper format if the field is a date, but FormatDateTime() is too dumb to use anything but its lame named formats. (Why MS chose VB as the sole expression language is beyond me!)

  Is there a simple way to format the date as I need or do I have to resort to Mid()s + WeekdayName() or doing it in SQL?

• Steven Cameron

  SSCrazy

  Points: 2903

  More actions

  August 1, 2008 at 11:04 am

  #852048

  I don't know a lot about vb but isn't there a FORMAT() function that does that?