I want to build an expression that hides a sheet based on a fixed date of 01/01/2099. So any date less than this date will show the sheet and any date greater than this date will hide the sheet. Can anyone assist?
Hi Sunny. this is close but what happens is because the date field (BILLING_END) has set values of 01/01/2099 the sheet is hidden all the time. What I am looking for is for the sheet to hid based on a selection.
Example: Customer 1 has assets with a billing start date of 01/01/2015 and an end date or 12/31/2099 in this case the sheet can stay hidden but if that same customer has an asset with a billing start date of 01/01/2015 and an end date of 01/01/2016 the sheet should be displayed. This can be complicated as my default view is to always show the sheet no matter what the condition is.
