https://community.jmp.com/t5/Discussions/How-to-filter-data-by-time-always-2-weeks-prior-to-current-time/m-p/611482#M81185 <P>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.</P> Thu, 08 Jun 2023 16:29:20 GMT lcpaul41 2023-06-08T16:29:20Z https://community.jmp.com/t5/Discussions/How-to-filter-data-by-time-always-2-weeks-prior-to-current-time/m-p/611482#M81185 <P>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.</P> Thu, 08 Jun 2023 16:29:20 GMT https://community.jmp.com/t5/Discussions/How-to-filter-data-by-time-always-2-weeks-prior-to-current-time/m-p/611482#M81185 lcpaul41 2023-06-08T16:29:20Z https://community.jmp.com/t5/Discussions/How-to-filter-data-by-time-always-2-weeks-prior-to-current-time/m-p/611643#M81190 <P>The Today() function returns the current datetime.&nbsp; Therefore you can select or exclude using a statement such as</P> <PRE><CODE class=" language-jsl">If( :DateTime &gt;= today()-inweeks(2), &lt;your specific action statements go here&gt; )</CODE></PRE> Tue, 14 Mar 2023 02:00:34 GMT https://community.jmp.com/t5/Discussions/How-to-filter-data-by-time-always-2-weeks-prior-to-current-time/m-p/611643#M81190 txnelson 2023-03-14T02:00:34Z