Joberlander

Grouping Time Dependent Records

Discussion created by Joberlander on Apr 14, 2016
Latest reply on Apr 14, 2016 by siplus

I am trying to create a list that shows a weekly summary of places visited, which is obviously time dependent, but I only get the records for the places by the day -- not a summary of week. I have a daily summary which works fine, but the weekly does not. Here is the script that I use:

Set Variable [ $$current_date ; Value: Get ( CurrentDate)]

Set Field [ Consultants::g_performance start date ; $$current_date ]

Set Field [ Consultant::g_performance end date ; $$current date - 7 ]

Show All Records

Sort Records [ Restore ; No Dialog ]

Find Matching Records [ Constrain ; Consultant::Last in Person Contact ]

Any suggestions/ contributions are much appreciated

Outcomes