[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Calculated Columns current week

Posted on 2014-02-11
1
Medium Priority
?
647 Views
Last Modified: 2014-02-11
Hi all,

I am trying to create a view that shows items for the current week.  

I found the following site that has a formula that captures the end of the current week in a date column.   I modified it and created the following formula
=AssignToAnalyst+(6-WEEKDAY(AssignToAnalyst))  The name of the calculated column is "EndOfWeek"

The formula works great but I am having a hard time filtering the view to just show this week (2/10/2014 - 2/14/2014). I used the formula in my calculated column called "EndOfWeek".

I need to filter in this way "EndOfWeek >= AssignToAnalyst && AssignToAnalyst <= EndOfWeek" something like that... Any ideas?

Here's my site: http://isaac.issharepoint.com/Lists/Log/AllItems.aspx
0
Comment
Question by:Isaac
1 Comment
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 39851427
Hello,

seems to me that there is a little flaw in the EndOfWeek formula, since for the value Feb-15-2014 the EndOfWeek is calculated as Feb-14-2014.

In my tests, the formula works better with

=AssignToAnalyst+(7-WEEKDAY(AssignToAnalyst))

Open in new window

but there may be reasons why you prefer the formula you have in place.

In any case, to filter by the current week, the filter needs to compare today's date with the current week.

So you'd need these two filters, combined with AND

EndOfWeek is less than or equal to [Today]+6

EndOfWeek is greater than or equal to [Today]

End of week filter
cheers, teylyn
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question