cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
lcpaul41
lcpaul41
Level I

How to filter data by time, always 2 weeks prior to current time

Created: Mar 13, 2023 03:27 PM  |  Last Modified: Jun 8, 2023 9:29 AM (839 views)

Hi, Wondering how to add a data filter that would pull data only from the last 2 weeks of collection, starting from the time the script is ran. I see how to manually set based on a specific date/time, but not how to have this continuously change with relation to the time it is ran. The data I am looking to filter has full time stamps already. Thank you.

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User txnelson
Super User
Solution

Re: How to filter data by time, always 2 weeks prior to current time

Mar 13, 2023 10:00 PM (825 views)  |  Posted in reply to message from lcpaul41 03-13-2023

The Today() function returns the current datetime.  Therefore you can select or exclude using a statement such as

If( :DateTime >= today()-inweeks(2), <your specific action statements go here> )
Jim

View solution in original post

1 REPLY 1
txnelson
Super User txnelson
Super User
Solution

Re: How to filter data by time, always 2 weeks prior to current time

Mar 13, 2023 10:00 PM (826 views)  |  Posted in reply to message from lcpaul41 03-13-2023

The Today() function returns the current datetime.  Therefore you can select or exclude using a statement such as

If( :DateTime >= today()-inweeks(2), <your specific action statements go here> )
Jim