How do I create a greater than 'date' expression?

[#1]

Rookie post:

I've created a straight table with 7 columns. One column is 'Expiration Date'. I only want to only show fields that are greater than '01/01/2016' without having to click on a button or filter list?

Can it be hard coded in as a set analysis expression?

TIA.

[Anonymous]

you can use set Analysis

{<[Expiration Date]={'>=01/01/2016'}>}

be sure that the data is exactly in same Format as your field

[#3]

Thanks for your quick reply.

That's what I originally thought and tried. But I'm obviously missing something in the process...

Do I add it as a calculation condition or a sorting expression or another way?

Also do I need to add 'Sum' to the beginning?

[Anonymous · Accepted solution]

that's right

you Need a calculation option like

=sum({<[Expiration Date]={'>=01/01/2016'}>}yourvalue)

or Count or ..

you may add additional set Analysis parts as well