Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

"This Week" Filter for Search Module for Task

Avatar

Level 10

I am working on an automation that is looking at whether a task was completed after the planned completion date and want to search tasks that were completed this week.

 

I was looking the options to set my filter in the search module and did not see an option to set to this week. 

 

Screenshot 2024-05-16 at 3.22.36 PM.png

 

Is it possible to set to a "this week" filter?

 

Thank you in advance!

2 Replies

Avatar

Level 10

Hello,

 

corresponding to the documentation of the setDay() function, this could be a way:

 

lgaertner_0-1715893859002.png

 

setDay (date; number/name of the day in english)

Returns a new date with the day specified in parameters. It can be used to set the day of the week, with Sunday as 1 and Saturday as 7. If the given value is from 1 to 7, the resulting date will be within the current (Sunday-to-Saturday) week. If a number is given outside of the range, it will return the day from the previous or subsequent week(s), accordingly.

 

 

Regards

Lars

Avatar

Community Advisor

You can use the same variables as in reporting, so $$TODAYbw and $$TODAYew.

Search parameters.png