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

[#1]

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.

[#2 · Accepted solution]

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> )