Solved

View selection

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
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.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

820 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