Hiding (Conditional) or filtering if less than ~ Date

[JeffLaB9]

Hello,

I'm trying to conditionally hide or filter results based on the "Last Issued Date". I've tried this in both the filter expression and as a conditional expression, but I just get errors when trying to test or load the report. I've referenced a few similar posts but they aren't working for me.

The field I need to base this on is called "DateLastIssue" and it is currently set as a datetime field. This field represents the last DateTime a specific item was issued.

I have tried...

Station.DateLastIssue <= Today.AddDays(-180)

>>> This results in an error that states "The name 'Station' does not exist in the current context"
>>> If I add the { } brackets, I just get a long list of errors
>>> I have tried this both as a condition on the specific "Text" fields, as well as a filter on the Datasource line. Both with the same results
>>> I have tried this with the result text fields in the DataSource field, as well as I have tried putting the result text fields in a GroupHeaderBand set as Station>DateLastIssue


I am unable to provide a copy of the database for testing as I don't have access to that server. The flow of the data source goes: SQL Server > Station (Table) > DateLastIssue (Item within table)

[JeffLaB9]

I kept playing around with it and it was something simple. I needed to bracket in my two groups. Working expression was...

(Station.DateLastIssue) <= (Today.AddDays(-180))

[Lech Kulikowski]

Hello,

Thank you for the information.