Skip to main content

Is there a way to use the shortened month name in a GI? I’ve tried using =MONTHNAME(EARInvoice.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). 

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

Perfect. So close but so far away I was. 

Reply


Terms & ConditionsCookie settings
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