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


Display Last 15 Days of Month in View

Posted on 2011-10-20
Medium Priority
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
  • 2
LVL 13

Expert Comment

ID: 37004940
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

Sjef Bosman earned 2000 total points
ID: 37004944
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

ID: 37005824
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

ID: 37005831
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses

873 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