Calculated date field in filter pane

[kevinstanfield]

Hi,

I'm trying to limit a date filter to only show dates that are greater than (Today() - 30) i.e the last 30-days + any future dates.

I've tried using a similar expression 

Sub_End_Date>=(Today()-30)

but it's not working
 I get a binary result -1, or 0, for dates that either meet or don't meet that condition

Thanks in advance.

Kevin

[sunny_talwar]

May be try this

If(Sub_End_Date>=(Today()-30), Sub_End_Date)

[kevinstanfield · Accepted solution]

Perfect Sunny - Thanks