crystal reports datepart and dateadd

select {shift}
case 1:
  datetime({begindatetime}) in datetime({currentdate}) to datetime({currentdate},ctime("11:59:59pm"))
case 2:
  datetime({begindatetime}) in datetime({currentdate}) to datetime(dateadd("d",1,{currentdate}),ctime("8:00am"))
default:
  datetime({begindatetime}) in datetime({currentdate}) to datetime({currentdate},ctime("11:59:59pm"))


something like this should help.

I tried this but it keeps giving me an error in this section
datetime({begindatetime}) saying that a date is required here.  But it is already a datetime field, so do I still need to convert to a datetime, or is that perhaps causing the error?

yes.. I was not sure if it was in datetime format or not.  CR will kick an error out if the column that you are apply such functions are already in that format. So remove the datetime and just leave the column name.

select {shift}
case 1:
  {begindatetime} in datetime({currentdate}) to datetime({currentdate},ctime("11:59:59pm"))
case 2:
  {begindatetime} in datetime({currentdate}) to datetime(dateadd("d",1,{currentdate}),ctime("8:00am"))
default:
  {begindatetime} in datetime({currentdate}) to datetime({currentdate},ctime("11:59:59pm"))


Now this also goes under the assumption you want to look at today.

well it should only be from {begindatetime}  until {begindatetime}  at midnight.

What is the purpose of the Shift parameter?  I am probably missing and there is more to this report.  The reason I ask is because (in my head) all records potentially could go into both shifts.  Are you doing some grouping by Person or date?  It might change the way you code this formula.

Well there are 2 different shifts in the factory, and the shiftID is noted in the table with the history records, On first shift, I can get all the records by looking where the shiftID=1 and the date is 4/18/2006 up until midnight.    But it does not help in the following case for 2nd shift.  They will only want to look at let's say 2nd shift for 4/18/2006.  But the shift rolls over into midnight and continues into the next day.
So 2nd shift may last from 5:00 PM on 4/18/2006 until 2:00 AM on 4/19/2006 and I want only those records, this is why I need the date range for 2nd shift to be the next day until 8:00 AM.  They change the times of their shifts, but I always know they will be in a certain range.  I am grouping by line and then station but not by date.  

so do you have a parameter that will allow date input if they want to see a specific day?

yes, there is a parameter for shift and begindate.
So basically they would pass in shift 1 on 4/18/2006
or shift 2 on 4/18/2006 (implying that it would return all data from the whole 2nd shift i.e. data that goes into 4/19/2006)

All right, that works great! Thanks