Choose Language Hide Translation Bar
Highlighted
Françoise
Level IV

filter with date

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
txnelson
Super User

Re: filter with date

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

View solution in original post

2 REPLIES 2
Highlighted
txnelson
Super User

Re: filter with date

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

View solution in original post

Highlighted
Françoise
Level IV

Re: filter with date

Thanks!
Article Labels

    There are no labels assigned to this post.