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