0

Filtering data based on manual dates entered.

Ok, another question here.  I feel I am in the ball park.  I am trying to sort my data based on when clients were terminated.  However, those dates I want to use can always change based on what information I want to pull, so I didn't want to put any static formula in place.  So created two date fields that a user can use to filter for dates.  I have tried using the following formula with no luck.

 

let startDate := date('Beginning Date');
let endDate := date('End Date');
count((select Clients)['Pretrial Termination Date' = (>= startDate) and 'Pretrial Termination Date' = (<= endDate)].'Termination Reason' = 1)

 

Beginning Date is the manual start date field

End Date is the manual end date field.

Clients is the Parent Table.  

Termination Reason =1 are all sentenced clients

Pretrial Termination Date is a field that is on every record where a date is put in when a client is terminated.  

 

Any help is greatly appreciated.  Thanks!

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Try this:

    count(select Clients ['Pretrial Termination Date' >= startDate and 'Pretrial Termination Date' <= endDate and 'Termination Reason' = 1])

    Like
  • Great success !!!  

    Like
Like Follow
  • Status Answered
  • 3 mths agoLast active
  • 2Replies
  • 18Views
  • 2 Following