Skip to main content

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.

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.

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

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