Suppress a text label if value falls within group range

Please open the attachment.

How can I suppress a text field if the Admitted date (blue) falls within the dynamic range of the date shown within the group (orange)? The Admitted Date doesnt have to be an actual value from the group date column, but if the date can be found within the dynamic range, I'd like the text field (Green) to be suppressed.
cr-issue.JPG
LVL 1
susnewyorkAsked:
Who is Participating?
 
mlmccCommented:
Try
Not {AdmittedDateFIeld} in Last30Days


If those are 2 dates in the record
Suppress with
DateDiff('d', {TreatmentPlanDate}, {AdmittedDateField}) > 30


mlmcc
0
 
mlmccCommented:
Not sure you can do it but try this in the suppression formula


{YourDateField} >= Minimum({DateRangeField})
AND
{YourDateField} <= Maximum({DateFieldRange})


mlmcc
0
 
susnewyorkAuthor Commented:
I had tried that but there is nothing limiting the formula to the groups dates.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
mlmccCommented:
Sorry.

{YourDateField} >= Minimum({DateRangeField},{Groupfield})
AND
{YourDateField} <= Maximum({DateFieldRange}, {Groupfield})

mlmcc
0
 
c0feeCommented:
I am assuming that the dates in the dynamic range (orange) are in the details and you are grouping on the user:

In the green field's Suppress conditional formula:

AdmittedDateField in minimum (OrangeDateField, UserField) to maximum (OrangeDateField, UserField)
0
 
c0feeCommented:
lol. mlmcc beat me to this. figures.
0
 
susnewyorkAuthor Commented:
I've been helped by mlmcc for at least 7 years under different user accounts. I'm testing this out now. Thanks.

I need to modify my original request a bit i think. I need to show the text field if the Admitted date falls within 30 days of the Treatment Plan Date within the details section. Any more ideas?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.