Parse ARTran.Date to show a column with just the date and month, not filtered

  • 14 June 2024
  • 2 replies

Userlevel 4

I have a GI which I would like to show a column with not only the date, but also show two columns with the Year and Month part of the date. I have tried using =CSTR(Year([ARTran.Date]), =CSTR(Month([ARTran.Date]), =Year([ARTran.Date]) (using the formula editor for the last one), but the column, sadly remains empty. I am not using it as a filter, just need the two added columns.


Best answer by wmatthews1877 14 June 2024, 14:39

View original

2 replies

Userlevel 4

I just figured it out. Duh!. The ARTran.Date doesn’t have anything in it. By using the ARTran.TranDate I am able to do what needs to be done.

Userlevel 7

Thank you for sharing your solution with the community @wmatthews1877!


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