Solved

Determine which Quarter of a year a date falls in

  • 23 June 2023
  • 2 replies
  • 48 views
D
Rank
Userlevel 4
Badge
  • Del
  • Freshman I
  • 39 replies

Is there a way in a Generic Inquiry to determine the which Quarter of a year a date falls in.

I am working on a Generic Inquiry where I would like to display the Quarter of the year the SOInvoice.DoDate falls in.

Thank you!

icon

Best answer by dcomerford 23 June 2023, 16:19

View original

2 replies

dcomerford
Rank
Userlevel 7
Badge +12

If you click on the pencil beside the Data field on the GI and then select Fields all the date fields appear and for the date fileds the date, day, hour, month, quarter can be selected so if you select the quarter one it will display the quarter number rather than the date

 

Dermot Comerford
D
Rank
Userlevel 4
Badge

Perfect!!

Thank you!!

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