Display date month only for date field

• hans.johnson

  Mr or Mrs. 500

  Points: 556

  More actions

  July 30, 2010 at 12:20 pm

  #224776

  Does anyone know if there's a date format I can use to display the month only for a date field? I'm doing a Birthday report and am using date ranges but I only want the month to display. The closest I can get is Month day e.g. "July 30". But, I only want "July" to appear in the report.

  Anyone know how to resolve this?

  Thank you for looking.

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  July 30, 2010 at 2:56 pm

  #1200550

  Use this as your expression

  =MonthName(Month(DateValueHere),False)