Question

Advanced Search Group by Month

  • 31 May 2023
  • 3 replies
  • 53 views
A
Rank
Userlevel 1
Badge +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
Rank
Userlevel 2
Badge +5

Had same question! Did you ever figure it out?

Sincerely, Jesse
Marcel.Ausan
Rank
Userlevel 6
Badge +15

@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
Rank
Userlevel 4
Badge +9

create a custom field for month?

Reply


Terms & ConditionsCookie settings