formula question

I believe it displays all records that are more than 30 days after the current date. Let me know if this helps.

<   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

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

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?

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?

the expression will be something like


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

so if workdatefield has  03/06/2007  for example...

...Then 03/06/2007 will display

not sure what that answer meant.

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?"

Remember, your question here was:
    <what does < Date() + 30 mean in access?>
Which I explained fully...

The original question was answered correctly.

ok