Print Page | Close Window

Max/Min Appt date

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=20863
Printed Date: 19 Apr 2024 at 3:15pm


Topic: Max/Min Appt date
Posted By: carmenv323
Subject: Max/Min Appt date
Date Posted: 07 Jul 2014 at 7:43am
I am looking for:

Last Appt & Next Appt w/same provider

I put in two separate formula fields with the following:

Maximum ({Appointments.ApptStart},{PatientProfile.MedicalRecordNumber})

Minimum ({Appointments.ApptStart},{PatientProfile.MedicalRecordNumber})

both of these are returning the same date which is the first appt...not sure why it's doing that and also how can I add to this "with the same provider", I have it grouped first by provider, then by MRN...any suggestions?



-------------
Progress is a process.


Replies:
Posted By: lockwelle
Date Posted: 29 Jul 2014 at 4:53am
I would assume that the grouping by provider then another grouping by MRN would give you the granularity you are after.

I am assuming that the ApptStart is a datetime field and that there is more than 1 appt for the individual...if so, I am not sure what is happening. If ApptStart is not a datetime, all bets are off, though you would expect that there would be a difference.

Posted By: NCGOV
Date Posted: 11 Mar 2020 at 8:44am
totext(Minimum({Appointments.ApptStart}),"MM/dd/yyyy")
totext(Maximum({Appointments.ApptStart}),"MM/dd/yyyy")

OR Try

Create a formula  - Date({Appointments.ApptStart})
then insert a summary for the minimum and the maximum of that formula

Good Luck!


Print Page | Close Window