@ZandyG: "Try this:
Create a new calculated field.  The calculation should be 
[your date field] + 1.
Then create a filter on your new field where it equals 
[Today].
Zandy
<quote>"
    @sam: "Zandy,
I don't understand how to do it. Can you elaborate more on 
it with an example? Particularly the concept why [your 
date field]+1. Thanks a lot!
<quote>
2003. 
[Today]-
on "
    @ZandyG: "Sure, I can try...
Setup:
Lets say I created a custom list with everyone's birthday 
in it.  So I have a few fields, one of which is BirthDay 
[date/time data type].  Being the "planner" that I am, I 
want to have a view on this list that will show people 
that have a birthday tomorrow (kind of the opposite of 
what the original post was asking, but the concept still 
holds).
In order to do this, I need to do the following steps:
1.  Create a new field on my list.  The "data type" should 
be "Calculated" and down below, it should ask you what 
type of data the calculation will return - choose 
date/time.  Furthermore, the calculation will be 
[Birthday]-1.  Lets call this field "CalcBirthday."
2.  Create a new view (or modify an existing view) such 
that in the Filter section, you choose the 
field "CalcBirthday," and "is equal to" and "[Today]".
To take an example...Today's date is 8/26/03.  One of the 
people on my list has a birthday of 8/27/03 (okay - not 
that practical, but it gets the point across).  Therefore, 
the "Birthday" field will be 8/27/03.  My "CalcBirthday" 
field (which is the "Birthday" field - 1) will be 
8/26/03.  Therefore, if I filter the "CalcBirthday" field 
by [Today], then I should get this person in my list.
Make sense?  Let me know if you have more questions...
Zandy
<email_address>
<quote>
on 
be "
    @kjetilborgersen: "I am facing the same problem. Your information was very 
helpfull, but can anyone explain to me how to create a new 
calculated field?
Thx,
- Chris
<quote>
2003. 
[Today]-
on "
{'source': 'USENET', 'other_information': '{"reply_count": 3, "forum_name": "microsoft.public.sharepoint.portalserver.20140713.mbox"}', 'file': 'data/output/usenet-microsoft.public.parquet'}