Hello everybody,
i do have a column in the following format: dd/mm/yyyy hh:mm:ss
I want do add a filter which shows only the last seven days.
Is there a possibility to do this? Unfortunately, I have no experience in scripting/JSL.
Thanks in advance.
I still have no idea how you want to use this "filter", so I cannot really provide more information.
I have attached modified version of JMP's sample data table Big Class with dates.
It has date column (generated with formula) and column which should tell if date is in last 7 days (also formula)
There is also table script which will create graph builder to with local data filter
Filter with week number (and year) or last seven days? And if last seven days which date should it be based on?
Filter last seven days based on current day.
Not sure where the filter will be, but you can get the date for example with something like this:
Names Default To Here(1); new_date = Today() - In Days(7); new_date = new_date - Time Of Day(new_date); As Date(new_date); //13May2022
Thank you. But where to paste this?
