Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Activity earlier than a specific time limit

Activity earlier than a specific time limit

Activity earlier than a specific time limit

Hi All,

I'm trying to use a datetime field that shows the last time a patient record was updated to determine which patient records have been inactive for 90 days. I have {Appointments.AuditUpdateDate} which contains the datetimes for each occasion a record was edited in a table which is linked to {Patient.PatientNumber} in a different table to provide patient information.

In this example I want to run a report that will return patient 123 because they only have activity that happened longer than 90 days ago, but I don't want to see 987 even though they had activity longer ago than 90 days because they also have recent activity.

Patient Number | Audit Date/Time
123 | 01/01/2121 08:00
123 | 01/02/2021 08:36
987 | 01/02/2021 14:00
987 | 08/19/2021 12:41
987 | 08/20/2021 13:21

I'm at a complete loss how to achieve this, any ideas? I'm using CR version connected via ODBC. I don't know the database type, it's managed by a third party who set up CR for me.

Thanks in advance!

RE: Activity earlier than a specific time limit

I would do it this way.
1. Create a group on Patient Number;
2. Enter the following Group Selection formula (Report => Selection Formula => Group):


Maximum({Table.Audit Date Time}, {Table.Patient ID}) < CurrentDate - 90 

Hope this helps

RE: Activity earlier than a specific time limit

Perfect, that did the job nicely. Thank you very much!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close