1st or last day missing from formula

Can anyone please help me along here?  I seem to be missing the 1st and/or last day from my reports with this formula that is currently in the Crystal Reports vs what I pull via Excel data connection.  

{@Closed Date} in {?Begin Date} to {?End Date}  

Many thanks....
captgriggs1Asked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
If it works it should be ok.

I generally do dates with a comparison as

{@Closed Date} >= {?Begin Date} AND {@Closed Date}  <= {?End Date}

In that way I know how the compare will work

mlmcc
0
 
mlmccCommented:
Is ClosedDate a date or Date Time?

How are you entering the parameters?

Are they dates or datetimes?

If you have a datetime chances are the dates being entered as values will either have 0:0: as the time or the current time appended.  Your closed date may match the date but have a time that is before the start datetime or after the end datetime.

mlmcc
0
 
captgriggs1Author Commented:
Thanks mlmcc, after your response, I added the -1 to my formula and it gets the information that I need but, I'm not really sure if it's the correct way or not.....  I'm using the Select Expert to build.  I am an extreme beginner at this.  Do you think this will serve the purpose?  (all dates, no time) Thanks

{CallLog.CallStatus} = 'Closed' and
{@Closed Date} = {?Begin Date}-1 to {?End Date} and
(if
{?Group Name} <> 'All'
then
{Assignee.GroupName} ={?Group Name}
else
{Assignee.GroupName} like "*")
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.