Skip to main content
Question

Advanced Search Group by Month

A
Do Gooder (Customer)
Forum|alt.badge.img+6

Hi,

 

Does anyone know how to group by month in advanced please?

 

upper( ORGANIZATION_ID ) = upper( 'klm' ) and upper( UNIT_CODE ) = upper( 'h' ) and CREATED_DATE between to_date( '20221201000000', 'YYYYMMDDHH24:MI:SS' ) and to_date( '20230531235959', 'YYYYMMDDHH24:MI:SS' )

 

3 replies

ACIJGARRIEPY
Sidekick (Customer)
Forum|alt.badge.img+5
  • ACIJGARRIEPY
  • Sidekick (Customer)
  • 6 replies
  • November 2, 2023

Had same question! Did you ever figure it out?

Sincerely, Jesse
Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Marcel.Ausan
  • Ultimate Hero (Partner)
  • 1142 replies
  • November 2, 2023

@a.george @ACIJGARRIEPY have you tried writing the below to_char function in the Group/Sum field of creation_date

to_char(creation_date, 'Month')
https://www.linkedin.com/in/marcelausan/
M
Sidekick (Customer)
Forum|alt.badge.img+9
  • mmoss
  • Sidekick (Customer)
  • 73 replies
  • November 2, 2023

create a custom field for month?

Reply


Terms & ConditionsCookie settings

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