Skip to main content

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

 

Had same question! Did you ever figure it out?

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

create a custom field for month?

Reply


Terms & ConditionsCookie settings