topic Re: Date Selection on Individual filters in App Development

Date Selection on Individual filters

Srikanth_595 — Fri, 27 Jan 2023 07:23:33 GMT

Need to create two individual filters(From date & To date ) from single date

when selects From date in To date i need show only future 30 days for selection

Need help!

rubenmarin — Sun, 29 Jan 2023 08:08:54 GMT

Hi, in an app with this script:

LOAD Date(Today()+RecNo()) as FromDate AutoGenerate 100; LOAD Date(Today()+RecNo()) as ToDate AutoGenerate 100;

I tried to add FromDate in a filter panel, and another panel with this calculated dimension for ToDate:

=Aggr(If(ToDate>=FromDate and ToDate<=FromDate+30, ToDate),ToDate)

Srikanth_595 — Thu, 02 Feb 2023 04:44:13 GMT

Hi Rubenmarin,

thanks for reply

I tried the above solution it was showing me the forecasting dates. But I need future dates which are present in table

I was trying like

Only({$<ToDate={">=$({$<GetFieldSelections(FromDate)<=GetFieldSelections(FromDate)+30)"}>} ToDate)

but dates are not reflecting in the filter throwing invalid dimension error

rubenmarin — Thu, 02 Feb 2023 07:37:03 GMT

Hi, the above was just an example, you don't have to copy or use the script part, just adapt

=Aggr(If(ToDate>=FromDate and ToDate<=FromDate+30, ToDate),ToDate)

to your fields.