Skip to main content
Solved

Shortened month name in a Generic Inquiry

  • Sep 19, 2024 7:12 PM UTC
  • 2 replies
  • 62 views
  • Translate All
Semi-Pro I
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)

View original
William J Matthews

    2 replies

    darylbowman
    Captain II
    Forum|alt.badge.img+17

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

    Translate
    Daryl 🧩 I build Acumatica add-ons 🔗deftstrokesdev.com/products?ref=forum_sig
      Semi-Pro I
      Forum|alt.badge.img+1
      • wmatthews1877
      • Author
      • Semi-Pro I
      • Sep 19, 2024 7:46 PM UTC

      Perfect. So close but so far away I was. 

      Translate
      William J Matthews
        Terms & ConditionsAccessibility statement
        About Acumatica ERP system
        Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
        © 2008 — 2024  Acumatica, Inc. All rights reserved