Solved

Calculated Columns current week

Posted on 2014-02-11
1
515 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 500 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

707 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