Improve company productivity with a Business Account.Sign Up

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

formula question

what does < Date() + 30 mean in access?
0
zachvaldez
Asked:
zachvaldez
1 Solution
 
TRTurnerCommented:
I believe it displays all records that are more than 30 days after the current date. Let me know if this helps.
0
 
Jeffrey CoachmanMIS LiasonCommented:
<   means less than
Date()   is the current date (Today)
+30   means add 30 days

So it basically means:
Dates Before Today's Date + 30 days

In other words, if today is 1/15/2012, then Date()+30 would be roughly 2/15/2012
Then the formula reduces to <2/15/2012 (Less than 2/15/2012)
So this expression get all dates before (Less than)  2/15/2012

JeffCoachman
0
 
Jeffrey CoachmanMIS LiasonCommented:
Note that the Date() returns the current date, and is dynamic.

Meaning if today was 7/2/2015
The expression would get all dates before 8/2/2015

;-)

JeffCoachman
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
zachvaldezAuthor Commented:
I have a datefield type  with a value of say

03/06/2007 .. so

03/06/2007  < Date() + 30

what should be displayed or not displayed?
0
 
Helen FeddemaCommented:
You are asking a question with that expression, so the return value would be True or False (probably not what you intend).  What are you trying to do here?
0
 
Jeffrey CoachmanMIS LiasonCommented:
Helen is correct, your question does not fit the expression....
Please explain *In Detail* exactly what you have, and exactly what you are trying to accomplish...

<Date()+30  would typically be put in a query as a date filter
Something like:
Only display records where SomeDate field is less than 2/15/2012

Examine this sample
Database115.mdb
0
 
zachvaldezAuthor Commented:
the expression will be something like


where ((workdatefield) < Date() + 30 )

so if workdatefield has  03/06/2007  for example...
0
 
Jeffrey CoachmanMIS LiasonCommented:
...Then 03/06/2007 will display
0
 
zachvaldezAuthor Commented:
not sure what that answer meant.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Not sure what your question meant...

Helen and I asked:
    "Please explain *In Detail* exactly what you have, and exactly what you are trying to accomplish..."
   "What are you trying to do here?"
0
 
Jeffrey CoachmanMIS LiasonCommented:
Remember, your question here was:
    <what does < Date() + 30 mean in access?>
Which I explained fully...
0
 
zachvaldezAuthor Commented:
The original question was answered correctly.
0
 
Jeffrey CoachmanMIS LiasonCommented:
ok
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

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