I would like to establish a way to be able to report and compare H1 (first 6 months of a year) vs. H2 in addition to the current options (quarters, months, weeks) for the most relevant date fields of a custom object.

Any suggestions?


For any other option than the current filters, you may need to resort to a formula field. For example:

TEXT(YEAR(MyDateField__c)) & " " & IF(MONTH(MyDateField__c)<7, 'H1','H2')

This would allow you to group by half-years in a report or SOQL statement.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.