Skip to Content
Former Member
Aug 02, 2016 at 06:06 PM

Split records by date


Hi All

I have a very simple task, but due to lack of experience I am unable to complete it.

Database field being used for the date: p_transaction_date

I want to have the report split into two sections based on the following criteria:

Group1: OLD Insurance

All data up until 30 June 2016 23:59:59

Group2: NEW Insurance

All data from 1 July 2016 00:00:00 onwards

Can this be achieved with grouping and formula's? Was unable to find a similar task on google, hence why I'm asking you helpful bunch of wizards 😊

Not sure how to setup my grouping to allow to above to be split into two seperate sections on the report.

Thanks in advance!