Hi, I'm pretty new to CR (2008 V12.3.0.601).

I have to write a report which gives the ship date for a specific time period. For example; On December 15th 2013 I need the report to show all sales which shipped between October 1st 2013 to October 15th 2013. Secondly on December 31st 2013 the report will show all sales shipped between October 16th 2013 to October 31st 2013.

Here's the code I have:
If {SORMASTER.ReqShipDate} >=  DATETIME (2013, 10, 01)
AND
{SORMASTER.ReqShipDate} <= DATETIME (2013, 10, 15)
AND {SORMASTER.OrderStatus} = "9"
Then {SORMASTER.ReqShipDate}

When I run the report I get the all of the items which shipped in October 2013. I assumed that the 9 would show only items which had shipped (Syspro) and not display any other items. Out of the  Six pages of data returned only Two pages contain the correct date range required.

Any help would be gratefully received.

Thanks.

Hi Thanks for the swift reply, your suggestion worked like a charm. I need to get more involved in crystal as doing the odd report now and again leaves me getting little experience.

I need two reports, one which covers the first half of the month in question, and a second report which gives data for the remainder of the month.

I can set the dates and then save the report with a different name and have them run automatically using EasyView

(
datepart('d',currentdate)>15 and {SORMASTER.ReqShipDate} in Monthtodate and datepart('d',{SORMASTER.ReqShipDate})<16
or
datepart('d',currentdate)<16 and {SORMASTER.ReqShipDate} in lastfullmonth and datepart('d',{SORMASTER.ReqShipDate})>15
)
and {SORMASTER.OrderStatus} = "9"