Date Field Expression

[pandreozzi]

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?

[sunny_talwar]

May be this as your sheet condition

Max(Date) < MakeDate(2099, 1, 1)

[pandreozzi]

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.

[sunny_talwar]

Might be easier if I can have a look at a sample?

[pandreozzi]

Ok, let me put some screen shots together and upload them tomorrow.

[pandreozzi]

Hi Sunny. I was able to put some screen shots together today but please do not feel like you need to reply today. If you have questions let me know.