Solved

View selection

Posted on 2004-08-18
2
158 Views
Last Modified: 2013-12-18
Hi Experts!  I have a view wherein I only want to display dates for the current month ....for example I have several data(see below)..i want to check if the dates in the date receive falls within the current month ...in my example below I have 2 records that should be displayed in my view that is miguel and bea only since their date receive falls within the current month of august ......hope you can help me out .....

Name     Type of Account       Date receive     Amount
elaine     individual                 07/01/2004      10,000.00
miguel    individual                 08/01/2004      50,000.00
bea        individual                 08/18/2004      30,000.00
john       individual                 06/25/2004      10.00000
0
Comment
Question by:emem
2 Comments
 
LVL 24

Accepted Solution

by:
HemanthaKumar earned 25 total points
ID: 11841120
Here is the formula

Select @Month(DATE_FIELDNAME) = @Month(@Today)

~Hemanth
0
 
LVL 19

Assisted Solution

by:madheeswar
madheeswar earned 25 total points
ID: 11849348
SELECT Form="YourFormname" & (@Month(YourDateField)=@Month(@Today))

0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

743 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

15 Experts available now in Live!

Get 1:1 Help Now