I have seen many requests about the date filter for current week using Sunday - Saturday and many users needing the week to be Monday - Saturday. This one issue is messing up my entire project. I understand Knack provides an option for Calendar views but that is not what I am looking for. I have pivot tables and grids that I need filtered by work week which is Monday - Saturday. Does anyone have a workaround or solution for this? This is needed asap and I cannot figure out what to do.
Hello,
I can develop this feature using custom JavaScript for you.
Feel free to reach out to me at rakesh.bajania@gmail.com if you’re interested.
Thanks!
Angie
You could possibly use an Equation field using the function getDateWeek. If you have any records on a Sunday that you wish to exclude for any reason, then you could use the function getDateDayOfWeek.
Dean
1 Like