Knowledge Drop

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


Userlevel 1

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.                

 

 


0 replies

Be the first to reply!

Reply