nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

get rows two weeks before today's date

Emma1

Hello,

In a script, I would like to be able to select rows that are two weeks before today's date.

I would like to run the script and depending on what day it is, that JMP displays the last two weeks only.

For that I used in my script the function "subset" and the function :

"get rows where" (: A> 40 &: A <59.5), and I would like to add something else to select the rows corresponding to two weeks before today's date (the date when I will run the script)

Thanks for your help

Have a good day

Accepted answers

txnelson

You need to make the selection in the data table before performing the Subset....see below

Names Default To Here( 1 );
dt = Current Data Table();

dt << select where( :A > 20 & :A < 40 & :Date >= (Today() - In Weeks( 2 )) );

dtSub = dt << subset(
	selected rows( 1 ),
	columns( :Year, :B, :Month, :Week, :Date, :Product, :A ),
	output table( "abc" )
);

I did not fully test the code, but it should be very close.

All comments

txnelson

In the Scripting Guide, under "Date Time" there is a list of all of the Date Time functions that are available. I assume you want to do something like:

theRows = dt << get rows where( :Date >= Today() - InWeeks(2));

or to adjust back to the beginning of the current date (i.e. Midnight)

theRows = dt << get rows where( :Date >= Today() - Time Of Day( Today() ) - InWeeks(2));

Emma1

Thanks, I tested this but it still doesn't work
What I'm looking to do is create a new base of my main database with a few columns I'm interested in and specifying that I only want column A with values between 20 and 40 and two weeks before today.
I have this:

dt = Current Data Table ();
dtSub = dt << subset (
Output Table ("abc"),
rows (dt << get rows where (: A> 20 &: A <40 &: Date> = Today () - InWeeks (2)));
columns (: Year,: B,: Month,: Week,: Date,: Product,: A)
);

Thanks

txnelson

You need to make the selection in the data table before performing the Subset....see below

Names Default To Here( 1 );
dt = Current Data Table();

dt << select where( :A > 20 & :A < 40 & :Date >= (Today() - In Weeks( 2 )) );

dtSub = dt << subset(
	selected rows( 1 ),
	columns( :Year, :B, :Month, :Week, :Date, :Product, :A ),
	output table( "abc" )
);

I did not fully test the code, but it should be very close.

Emma1

Hello,

Sorry but I tried your code but still can't do it ..
I'm new to script programming, so I don't have the reflexes that others can have in this kind of little script

Can I still ask you for help?
Thank you