topic Re: filter with date in Discussions

filter with date

Françoise — Fri, 17 Apr 2020 10:39:34 GMT

Hi,

In a dashboard, I have a filter with week numbers which applies to graphs. H

How to do in the script to have a selection of weeks which is updated from the last 3 weeks from today's date ans would be automatic?

best regards

Re: filter with date

txnelson — Fri, 17 Apr 2020 10:50:31 GMT

If your column's name is Date, and your reference to the data table is dt....this code will select the rows that fall within the last 3 weeks from today

dt << select where( :Date >= today() - in weeks(3) );

Re: filter with date

Françoise — Mon, 20 Apr 2020 15:17:46 GMT

Thanks!