Week as range for the filter if condition is met.

Question

I have this code which gets the current week as range for the Filter Tool. From Monday to Sunday (dates)

I want it to also check if it's Monday when ever I run the workflow. If it is Monday then the range for the filter should be Monday - Sunday of the past week.

If it's not Monday it should work as it is and get this week as range.

Any guesses?

DateTimeTrim([DATE],'days') >=
DateTimeTrim(
DateTimeAdd(
DateTimeTrim(DateTimeNow(),'year')
,8-ToNumber(DateTimeFormat(DateTimeTrim(DateTimeNow(),'year'),'%u')) +
(ToNumber(DateTimeFormat(DateTimeNow(),'%W'))-1)*7
,'days')
,'days')
AND
DateTimeTrim([DATE],'days') <=
DateTimeTrim(
DateTimeAdd(
DateTimeTrim(DateTimeNow(),'year')
,8-ToNumber(DateTimeFormat(DateTimeTrim(DateTimeNow(),'year'),'%u')) +
(ToNumber(DateTimeFormat(DateTimeNow(),'%W'))-1)*7 +
6
,'days')
,'days')

soncoku · Accepted Answer

Solved by:  @RolandSchubert

DateTimeTrim([DATE],'days') >=
DateTimeTrim(
DateTimeAdd(
DateTimeTrim(DateTimeAdd(DateTimeNow(), DateTimeFormat(DateTimeNow(), '%u') = '1', 'day'),'year')
,8-ToNumber(DateTimeFormat(DateTimeTrim(DateTimeAdd(DateTimeNow(), DateTimeFormat(DateTimeNow(), '%u') = '1', 'day'),'year'),'%u')) +
(ToNumber(DateTimeFormat(DateTimeAdd(DateTimeNow(), DateTimeFormat(DateTimeNow(), '%u') = '1', 'day'),'%W'))-1)*7
,'days')
,'days')
AND
DateTimeTrim([DATE],'days') <=
DateTimeTrim(
DateTimeAdd(
DateTimeTrim(DateTimeAdd(DateTimeNow(), DateTimeFormat(DateTimeNow(), '%u') = '1', 'day'),'year')
,8-ToNumber(DateTimeFormat(DateTimeTrim(DateTimeAdd(DateTimeNow(), DateTimeFormat(DateTimeNow(), '%u') = '1', 'day'),'year'),'%u')) +
(ToNumber(DateTimeFormat(DateTimeAdd(DateTimeNow(), DateTimeFormat(DateTimeNow(), '%u') = '1', 'day'),'%W'))-1)*7 +
6
,'days')
,'days')