topic Re: Calculated date field in filter pane in App Development

Calculated date field in filter pane

kevinstanfield — Fri, 22 Feb 2019 15:59:17 GMT

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

Re: Calculated date field in filter pane

sunny_talwar — Fri, 22 Feb 2019 16:08:01 GMT

May be try this

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

Re: Calculated date field in filter pane

kevinstanfield — Fri, 22 Feb 2019 16:28:46 GMT

Perfect Sunny - Thanks