Solved

View selection

Posted on 2004-08-18
2
164 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
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…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Suggested Courses

617 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