Print Page | Close Window

Is there a way to select 2 seperate date periods?

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22648
Printed Date: 29 Apr 2024 at 12:48am


Topic: Is there a way to select 2 seperate date periods?
Posted By: anoble1
Subject: Is there a way to select 2 seperate date periods?
Date Posted: 24 Jul 2018 at 4:44am
I have a report that I need to create where I need to show the first 6 months of 2017 and the first 6 months of 2018 Sales by customer.
Is there a way I can have 2 separate dates?

Customer    Sales 2017               Customer     Sales 2018
asdf            $2000.00                 asdf              $30000


Replies:
Posted By: kevlray
Date Posted: 25 Jul 2018 at 4:27am
Yes, but you probably will have to put in a formula in the select expert.

Something like this (very generic, syntax may not be correct).
{somedatefield} between date(2017,01,01) and date(2017,06,30) or
{somedatefield} between date(2018,01,01) and date(2018,06,30)


Print Page | Close Window