Solved

HOW DO I SELECT CURRENT DATE IN ACCESS EXPRESSION

Posted on 2014-07-23
2
198 Views
Last Modified: 2014-07-23
91-120: Sum(((IIf([True Date]<=#7/15/2014#-91 And [True Date]>=#7/15/2014#-120,[AMOUNT_BILLED],0))))

I need to change 07/15/14 to what ever the current date is.
0
Comment
Question by:garyrobbins
2 Comments
 
LVL 4

Accepted Solution

by:
Mitchell Milligan earned 500 total points
ID: 40214779
The command: Date() should help you out there.  That returns the current date.
0
 

Author Closing Comment

by:garyrobbins
ID: 40214916
Works Great.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
This video walks the viewer through the process of creating an MLA formatted document, as well as a bibliography with citations.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

839 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