Conditional Suppression Based on Date
We are trying to use Conditional Suppression to suppress rows based on a date. In Planning, users enter a date at an Account set to a Data Type of "Date." This same intersection is pulled into a report in Narrative Reporting. We would like to be able to set up conditional formatting to suppress rows if the date is prior to December 31st, 2023.
Based on testing, it appears that the "Date" in NR is text based. Therefore, we cannot use the greater than/less than operators to evaluate the date as a value. Attempting to use Planning date value (for example 20231231) also did not work. We can only get the suppression to work if we use the other operators and specify the specific date as it appears in the report (for example, Dec 5, 2036) which is not a dynamic/usable solution.