Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how do i find forms with date field + 3days 1

Status
Not open for further replies.

MrWilson

Technical User
May 20, 2004
9
GB
i have a view with a date field and would like to find any forms where the field is set three days from today.
ie @Today+3
 
Allow me a slight correction : you would like to find documents where a field value is a given date.
Forms are a design element, actual data is stored in documents that can be displayed by using a form.
Sorry for being pedantic, but it is important to use the right words.

What you need depends on what exactly it is you want. Do you want the view to contain only document records whose field is set to a specific date ? Or do you want a view that displays all document records and categorizes them by date ?

If it is the former option, you need a View Selection formula like this :
Code:
SELECT @Adjust(@today;0;0;3;0;0;0)=@date(fieldname)

Pascal.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top