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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • 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 CoachmanCommented:
<   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 CoachmanCommented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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 CoachmanCommented:
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 CoachmanCommented:
...Then 03/06/2007 will display
0
 
zachvaldezAuthor Commented:
not sure what that answer meant.
0
 
Jeffrey CoachmanCommented:
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 CoachmanCommented:
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 CoachmanCommented:
ok
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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