Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: Max/Min Appt date Post Reply Post New Topic
Author Message

Joined: 20 May 2014
Location: United States
Online Status: Offline
Posts: 2
Quote carmenv323 Replybullet Topic: Max/Min Appt 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?

Edited by carmenv323 - 07 Jul 2014 at 7:44am
Progress is a process.
IP IP Logged

Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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.
IP IP Logged

Joined: 04 Oct 2016
Online Status: Offline
Posts: 24
Quote NCGOV Replybullet Posted: 11 Mar 2020 at 8:44am

OR Try

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

Good Luck!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.016 seconds.