Skip to main content
Question

Advanced Search Group by Month

  • May 31, 2023
  • 3 replies
  • 110 views
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' )

 

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

create a custom field for month?


Terms & ConditionsCookie settingsAccessibility statement