Dates: How to search for all thing expiring end of week?

Need help
1

Hi Bubblers,

A datatype has a field with deadline (date). How would I search for all things with a deadline of this week or less (before saturday)? Also how to search for all things with a deadline before the end of the month?

Cheers,
Jason

2

Constraint
Due date =< current date +7 days, round down to the week (you may need to change hours to 0 and change minutes to 0)

3

Thanks, Jared. Quick and easy. Appreciate your help.

4

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