Solved

Date is within the current week in Crystal Reports

Posted on 2016-11-29
2
46 Views
Last Modified: 2016-11-29
Hi Experts

I have what I thought was going to be very simple but I can't seem to get any of my solutions to work.  I have a modified date as one field and I want to make sure that the query only records modified within the current week. (begins on a Monday).  Any help would be very appreciated.  

Andy
0
Comment
Question by:spudmcc
2 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 41906305
Can the date be in the future?

Try this

{DateField} > Maximum(LastFullWeek)

mlmcc
0
 

Author Closing Comment

by:spudmcc
ID: 41906425
This worked perfectly.  Thank you so much once again for your help.  So much appreciated as always.

A
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

Suggested Solutions

Title # Comments Views Activity
Execute a crystal report from vb2010 3 39
Crystal Reports Swap Columns 2 51
Getting a signature to show in Crystal Reports 2 60
Business Object Server 2 27
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…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

895 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

15 Experts available now in Live!

Get 1:1 Help Now