ICHIST Query 1

[dtmb]

How can I query ICHIST to produce two different set of data on the same report i.e using two similar parameters but for different time periods.

Thanks

 

[ettienne]

You will have to use formula to pull data for a time period, something like
If TRANSDATE >= 20080101 AND TRANSDATE <= 20080131 THEN .....
for the one date range and
If TRANSDATE >= 20071101 AND TRANSDATE <= 20071231 THEN .....
for the second date range.

 

[dtmb]

Thanks, did exactly that, put they overwrite each other.

 

[ettienne]

Put them in separate columns.