Date Selection on Individual filters

[Srikanth_595]

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]

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]

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]

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.