How do I create a custom filter for "today or 2 weeks ago?" to show only 2 dates in the explore for comparison

Knowledge Drop

Last tested: May 6, 2020
 

First we have to construct the date for 'today', and then use an OR with add_days on that 'today' date It ends up like this: ${history.created_date}=date(extract_years(now()),extract_months(now()),extract_days(now())) OR ${history.created_date}=add_days(-14,date(extract_years(now()),extract_months(now()),extract_days(now())))

This content is subject to limited support.                

Version history
Last update:
‎07-07-2021 01:14 PM
Updated by: