Skip to main content
Question

Advanced Search Group by Month

A
Do Gooder (Customer)

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' )

 

ACIJGARRIEPY
Sidekick (Customer)
Forum|alt.badge.img+5

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)
  • 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
Hero (Customer)
Forum|alt.badge.img+10
  • mmoss
  • Hero (Customer)
  • November 2, 2023

create a custom field for month?

Reply


Terms & ConditionsCookie settingsAccessibility statement

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