cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.
Choose Language Hide Translation Bar
Françoise
Level VI

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
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
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
Françoise
Level VI

Re: filter with date

Thanks!

Recommended Articles