Display Last 15 Days of Month in View

Posted on 2011-10-20
Last Modified: 2013-12-18
I have a view that I need to build that only needs to display the information for the last 15 days of each month.  I have an area that runs a report on that data.  Is there way in a view to only show items from the 15 to the 30/31 only.  I have a Date field that is calculated on compose and is set to @Created.  Any suggestions would be most helpful.

Thanks Experts!
Question by:kali958
    LVL 13

    Expert Comment

    Use lotusscript to search for the documents that meet your criteria and drop the result collection in a folder (instead of a view).
    You might even be able to create your report on that collection instead of the view/folder.

    A view might work, but is certainly not a recommendation: every @Today or @Now formula will trigger the indexer. Your server won't get a second of rest after you've built a view like that!
    LVL 46

    Accepted Solution

    Do you want to see the last 17 days of the current month, the previous month, or of all months? The latter isn't too difficult, the other two are somewhat more complex.

    For the not too difficult one, use this selection formula (or your own improved version):

    Day:= @Day(YourDateField);
    Select Day>=15

    but I expect it isn't that what you want...

    Author Comment

    Sjef - you were right. I wanted a view that should group the entries by month but only show the last 15/17 days of the month.  I have a department that only wants a report for that.  Maybe writing something would be better. I was thinking that I could put a field on the form that would calc the date and just show the number (such as 10/21/2011 would say "21") and then write a filter on the view that ways only show the days that are greater then 15, like you have.  I want to stay way from any @Today/@created in the filter due to what CRAK states with the index.

    What about something if I had a field on the form that would say show the days >=15 by days <=31?

    Does that sound reasonable?

    Author Closing Comment

    That worked. Using the @Day and then setting the greater then.  I tested it this morning. Totally what I was looking for.  Again Sjef, awesome answer!!! Thanks so much! :)

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
    Article by: Rob
    Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now