Solved

1st or last day missing from formula

Posted on 2014-04-08
3
204 Views
Last Modified: 2014-04-12
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....
0
Comment
Question by:captgriggs1
  • 2
3 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 39987347
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
 

Author Comment

by:captgriggs1
ID: 39987736
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
 
LVL 100

Accepted Solution

by:
mlmcc earned 100 total points
ID: 39987789
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now