Solved

View selection

Posted on 2004-08-18
2
159 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
DAOS - Backup / Restore 2 180
Domino Application - View Refresh on Subform 15 95
Switching from Lotus Notes to Outlook 4 46
Lotus Notes Calendar Issue 5 105
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

919 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

17 Experts available now in Live!

Get 1:1 Help Now