topic Date filter in App Development

Date filter

Arvind_07 — Sat, 16 Nov 2024 17:21:59 GMT

Hi,

I have a custom calendar data. Week number and Month starting/end date is different. But i have the Date field which is linked to week number and month based on my calendar.

I want to apply the default filter where I can get last week Sunday's date on the Date field when I open the app on any day during the current week.

Is there a function to apply on the filter to get the last week Sunday's Date on the Date field?

P.S. I will be having the Dates from 2020 to Dec 2021 on my Dashboard

Attached is my calendar

Re: Date filter

GaryGiles — Tue, 23 Mar 2021 11:28:55 GMT

The WeekStart() function will give you the Sunday date previous to the date supplied as a parameter.

So, WeekStart(Today()) will give you 3/21/2021. WeekStart(Today()-7) will give you 3/14/2021. (Note: Today is 3/23/2021)

You can setup a Sheet Action in the Sheet Properties panel of your default sheet bookmark. Select Add Action, and choose "Select values in field" and enter WeekStart(Today()) or WeekStart(Today()-7), depending on which Sunday you are referring to.

Re: Date filter

Arvind_07 — Tue, 23 Mar 2021 13:29:23 GMT

Thank you Gary for the solution. Is it possible to sort the Week Number filter and Month filter values in an ascending order- Like W01 2020- WK52 2020 and then W01 2021- WK52 2021 and the same goes for Month(Like Jan 2020- Dec 2020, Jan 2021-Dec 2021.

I have attached the Calendar file already which has this information.