Solved

Calculated Columns current week

Posted on 2014-02-11
1
442 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 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Work Over Net is a new and very powerful collaboration product. With its new easy interface it is becoming very competitive to other similar products like webex and office interactive. WON 2010 have the standard business tools needed for multi-offic…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

803 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