formula question

what does < Date() + 30 mean in access?
zachvaldezAsked:
Who is Participating?
 
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
 
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
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
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
 
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
 
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.

All Courses

From novice to tech pro — start learning today.