Print Page | Close Window

Testing

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11106
Printed Date: 27 Apr 2024 at 9:07am


Topic: Testing
Posted By: tarunjain
Subject: Testing
Date Posted: 14 Sep 2010 at 8:49am
Testin



Replies:
Posted By: DBlank
Date Posted: 14 Sep 2010 at 9:03am
what is the field that you are defining as the due date and do you want to show things that are past due?
 
Likely you will just want to use a datediff, something like ...
 
datediff('d',currentdate,table.duedate)<={?param}


Posted By: tarunjain
Date Posted: 14 Sep 2010 at 10:16am

Thanks for your reply. actually I used it. I want data according to date prompt. If user will enter tomarow date then data will popup for Tomarow and today only.



Posted By: DBlank
Date Posted: 14 Sep 2010 at 10:27am
so you want them to enter one date and return any row that has a value bewteen that date (in the future) and today?
 
table.datefield in currentdate to {?paramdate}



Print Page | Close Window