Is there a cleaner way to write this expression?

image

This expression is used to search for novels recommended this week. It works, but I feel like it could be more streamlined.

Also, does anyone know of any tutorials or resources focused on building expressions?

1 Like

:rounded down to is the operator you’re looking for.

Requested date >= Current date time rounded down to week

Requested date < Current date time rounded down to week + weeks (1).

The second constraint is likely redundant unless you schedule recommendations in advance - the second constraint stops you getting recommendations for future weeks.

Omg that was fast, thanks.

So first expession works perfectly.

the +weeks one, i don’t seem to have.

image

actually, i can just do plus 7 days. that works as well.

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.