Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 166
  • Last Modified:

View selection

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
emem
Asked:
emem
2 Solutions
 
HemanthaKumarCommented:
Here is the formula

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

~Hemanth
0
 
madheeswarCommented:
SELECT Form="YourFormname" & (@Month(YourDateField)=@Month(@Today))

0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now