Group by month or year with datetime field.

Comments

• FAlvarado US/Mexico

  December 2022 edited December 2022

  Break the group on expression:

  MonthOf(<frxDBDataset1."StartedOn">)

  YearOf(<frxDBDataset1."StartedOn">)

  Francisco Alvarado
• gpi

  January 2023

  Use

  YearOf(<frxDBDataset1."StartedOn">)*100 + MonthOf(<frxDBDataset1."StartedOn">)

  for month and year condition