Finding 'things' where whatever date field is the same as the current day

Need help
1

I am creating a simple scheduling application for a client and am create ‘today’ and ‘this week’ views so users can see what appointments they have today in a widget, and ‘at a glance’ for this week.

I don’t know how to strip away the time to just match by the day. For ‘this week’, I want to show everything from the sunday to saturday and I don’t know how to find whatever the date is for the sunday and saturday.

2

Hi there, @agiledood… for both today and this week, you need two constraints. For today, the constraints would be appointment date >= Current date/time:rounded down to date and appointment date < Current date/time:rounded down to date +(days): 1. For this week, the constraints would be appointment date >= Current date/time:rounded down to week and appointment date < Current date/time:rounded down to week +(days): 8.

Hope this helps.

Best…
Mike

2 Likes
3

beauty clark, works like a charm!

1 Like