cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-411003%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%89%8D%E5%B9%B4%E3%82%92%E9%81%B8%E6%8A%9E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-411003%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E3%81%84%E3%81%8F%E3%81%A4%E3%81%8B%E3%81%AE%E6%9C%88%E6%AC%A1%E3%83%AC%E3%83%9D%E3%83%BC%E3%83%88%E3%82%92%E8%87%AA%E5%8B%95%E5%8C%96%E3%81%99%E3%82%8B%E9%81%8E%E7%A8%8B%E3%81%AB%E3%81%82%E3%82%8A%E3%80%81%E5%BF%85%E8%A6%81%E3%81%AA%E3%83%87%E3%83%BC%E3%82%BF%E3%82%92%E9%81%B8%E6%8A%9E%E3%81%99%E3%82%8B%E3%81%AE%E3%81%AB%E5%95%8F%E9%A1%8C%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82%20%E6%97%A5%E4%BB%98%E3%81%AE%E5%88%97%E3%81%8C%E3%81%82%E3%82%8B%E3%81%A8%E3%81%97%E3%81%BE%E3%81%99%E3%80%82%20%E4%BB%8A%E6%9C%88%E3%81%AB%E5%9F%BA%E3%81%A5%E3%81%84%E3%81%A6%E9%81%8E%E5%8E%BB12%E3%81%8B%E6%9C%88%E3%81%AE%E3%83%87%E3%83%BC%E3%82%BF%E3%82%92%E9%81%B8%E6%8A%9E%E3%81%99%E3%82%8BJSL%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%E3%81%8C%E6%AC%B2%E3%81%97%E3%81%84%E3%81%AE%E3%81%A7%E3%81%99%E3%81%8C%E3%80%82%3CBR%20%2F%3E%E4%BE%8B%EF%BC%9A%E7%A7%81%E3%81%9F%E3%81%A1%E3%81%AF2021%E5%B9%B48%E6%9C%88%E3%81%AB%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%20%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%E3%81%A72020%E5%B9%B48%E6%9C%88%E3%81%8B%E3%82%89%E7%8F%BE%E5%9C%A8%E3%81%BE%E3%81%A7%E3%81%AE%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E6%97%A5%E4%BB%98%E3%82%92%E9%81%B8%E6%8A%9E%E3%81%97%E3%81%9F%E3%81%84%E3%81%A8%E6%80%9D%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%20%E6%9D%A5%E6%9C%88%E3%81%AE9%E6%9C%88%E3%81%AB%E3%81%AA%E3%82%8B%E3%81%A8%E3%80%812020%E5%B9%B49%E6%9C%88%E3%82%92%E9%81%B8%E3%82%93%E3%81%A7%E4%BD%95%E3%82%82%E8%A8%80%E3%82%8F%E3%81%9A%E3%81%AB%E7%99%BA%E8%A1%A8%E3%81%97%E3%81%9F%E3%81%84%E3%81%A8%E6%80%9D%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%3CBR%20%2F%3E%E3%81%93%E3%82%8C%E3%81%A9%E3%81%86%E3%82%84%E3%81%A3%E3%81%A6%E3%81%99%E3%82%8B%E3%81%AE%EF%BC%9F%20Access%E3%82%84PowerBI%E3%81%AA%E3%81%A9%E3%81%AE%E4%BB%96%E3%81%AE%E3%82%A2%E3%83%97%E3%83%AA%E3%82%B1%E3%83%BC%E3%82%B7%E3%83%A7%E3%83%B3%E3%81%AE%E3%82%A4%E3%83%B3%E3%82%BF%E3%83%BC%E3%83%95%E3%82%A7%E3%82%A4%E3%82%B9%E3%81%AB%E3%81%AF%E3%80%8C%E5%89%8D%E5%B9%B4%E3%82%92%E9%81%B8%E6%8A%9E%E3%80%8D%E6%A9%9F%E8%83%BD%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%81%8C%E3%80%81JMP%E3%81%A7%E5%90%8C%E6%A7%98%E3%81%AE%E6%A9%9F%E8%83%BD%E3%82%92%E8%A6%8B%E3%81%A4%E3%81%91%E3%82%8B%E3%81%93%E3%81%A8%E3%81%8C%E3%81%A7%E3%81%8D%E3%81%BE%E3%81%9B%E3%82%93%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-411003%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%86%E3%82%A3%E3%83%B3%E3%82%B0%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-845874%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%E5%89%8D%E5%B9%B4%E3%82%92%E9%81%B8%E6%8A%9E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-845874%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3ELearnBot%20%E3%81%AE%E6%8F%90%E6%A1%88%E3%82%88%E3%82%8A%E3%82%82%E3%81%86%E3%81%BE%E3%81%8F%E6%A9%9F%E8%83%BD%E3%81%97%E3%81%BE%E3%81%99%E3%80%82%E3%82%A2%E3%83%89%E3%82%A4%E3%83%B3%E3%81%8C%E3%82%B3%E3%83%9F%E3%83%A5%E3%83%8B%E3%83%86%E3%82%A3%E6%8A%95%E7%A8%BF%E3%81%8B%E3%82%89%E3%81%AE%E8%BF%94%E4%BF%A1%2F%E5%9B%9E%E7%AD%94%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%A7%E3%81%8D%E3%82%8B%E3%81%A8%E4%BE%BF%E5%88%A9%E3%81%A7%E3%81%99%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
benc
Level I

Select Previous Year

I'm in the process of automating some monthly reports, and am having trouble selecting the data I need. Suppose there is a column of dates. I would like a JSL script that selects the previous 12 months of data, based on the current month.
Example: We are in August 2021. I would like the script to select all dates from August 2020 to present. Next month when it is September I would like it to select September 2020 to present without any input from me.
How can I do this? Some other applications like Access and PowerBI have a "Select Previous Year" feature in their interface, but I can't find anything similar in JMP.

3 REPLIES 3
txnelson
Super User

Re: Select Previous Year

One way to do this is

dt = current data table();
dt << select where(:date >= DateMDY(month(today()),1,year(today())-1);
dtSub = dt << subset(selected rows(1), selected columns(0));
Jim
jthi
Super User

Re: Select Previous Year

I strongly suggest using Date Increment function with tasks like this. Below is an example with two different dates:

Names Default To Here(1);
date1 = Date DMY(15,8,2021);
date2 = Date DMY(1,9,2021);
Show(Date Increment(date1, "month", -12, "start")); //Date Increment(date1, "month", -12, "start") = 01Aug2020;
Show(Date Increment(date2, "month", -12, "start")); //Date Increment(date2, "month", -12, "start") = 01Sep2020;
Show(Date Increment(Today(), "month", -12, "start")); 

Here is a version to be used with data table with :date column:

Names Default To Here(1);
dt = Current Data Table();
dt << Select Where(:date >= Date Increment(Today(), "month", -12, "start"));
-Jarmo
Luis_HC
Level II

Re: Select Previous Year

Works better than the LearnBot suggestion. Would be nice if the add-in could use replies/answers from the community posts

Recommended Articles