Skip to main content
Answer

Shortened month name in a Generic Inquiry

  • September 19, 2024
  • 2 replies
  • 33 views

Forum|alt.badge.img+1

Is there a way to use the shortened month name in a GI? I’ve tried using =MONTHNAME([ARInvoice.DocDate]) which gives me the full month name. I’ve tried using =MONTHNAME(‘mmm’,[ARInvoice.DocDate]) and that gives me an error stating invalid token at position 12 (or whatever the number is). 

Best answer by darylbowman

Try =Left(MonthName([ARInvoice.DocDate]),3)

2 replies

darylbowman
Captain II
Forum|alt.badge.img+15
  • Answer
  • September 19, 2024

Try =Left(MonthName([ARInvoice.DocDate]),3)


Forum|alt.badge.img+1
  • Author
  • Semi-Pro I
  • September 19, 2024

Perfect. So close but so far away I was.