filter with date

Question

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

txnelson · Accepted Answer

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