Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Correct date in a sequence 1

Status
Not open for further replies.

hbussell

Technical User
Mar 19, 2001
13
US
I have a series of appointment dates in a table for a particular person. I have already selected the person using other data. I now want to add the next appointment date that falls after the current date. lets say I have 06/01/01, 06/15/01, 06/28/01, and 07/02/01 and my report date is 06/20/01. What would be the selection formular to select and print 06/28/01? Any help would be much appreciated.

Thanks
Harold
 
{Apt.date} >= currrentdate

Of course using this as a selection formula will exclude the other dates from the report. Ken Hamady
On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.
 
Thanks Ken. I used it in an If Then Else and it worked fine

Harold
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top