Skip to main content
Solved

Determine which Quarter of a year a date falls in


Forum|alt.badge.img
  • Freshman I
  • 42 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!

Best answer by dcomerford

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

 

View original
Did this topic help you find an answer to your question?

2 replies

dcomerford
Captain II
Forum|alt.badge.img+15
  • Captain II
  • 646 replies
  • Answer
  • June 23, 2023

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

 


Forum|alt.badge.img
  • Author
  • Freshman I
  • 42 replies
  • June 23, 2023

Perfect!!

Thank you!!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings