Filtering date range based on condition

[johandilipsamuel]

Hi

I have a scenario where I am stuck for the last two days

I need to filter last week(Sunday to Saturday) based on whatever day it is today because the case may run any day in the week. Whatever day it is, I need to filter only last week. 

[Akash__on]

Just provide some sample data and desired output needed.

regards,

aakash

[PhilipMannering · Accepted solution]

Hi @johandilipsamuel 

You could try shoving this expression in a Filter Tool,

tonumber(datetimeformat([date], '%U')) = 
tonumber(datetimeformat(datetimetoday(), '%U')) - 1

Let me know if this works!

Thanks

[PhilipMannering]

Here's the workflow that worked for me....

[Adrian_T · Accepted solution]

Hi @johandilipsamuel,

There are a few DateTime Functions that you would have to be using here: DateTimeFormat, DateTimeToday and specifier "%U" which returns week number.

The formula below looks up on the week number of Today, then filters your date column by today's week number - 1.

IF ToNumber(DateTimeFormat([Date],"%U")) = ToNumber(DateTimeFormat(DateTimeToday(),"%U")) - 1
THEN "Keep"
ELSE Null()
ENDIF

Sample workflow is attached. Hope this helps!