filter with date

[#1]

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

[#2 · Accepted solution]

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) );

[#3]

Thanks!