finding date range in portal

[thebrianexp]

Ok.

i have a portal that has a todo date, type, info, and notes.

i have a button that finds less than or equal to today from the portals todo date.

however, often it shows the first entry in the potral which could be tomorrow.

im very confused.. any help?

[mr_vodka]

If you perform a find in the portal, if the date in any of the related records meet your find criteria, it will give the parent records as part of your result set.

If you want to only show records in your portal that are "less than or equal to today" then try to use some filtered portals or create a relationship based on gCurrentDate >= Yourdate, where gCurrentDate is a global field Date that you set upon startup.

[thebrianexp]

im not searching in the portal, im clicking a button that goes to a new layout that pulls records from the portal. (unless thats what you are talking about)

what are filtered portals, and how would i do what you are suggesting?

[mr_vodka]

im not searching in the portal, im clicking a button that goes to a new layout that pulls records from the portal.

: I am not suure what you mean by this... You click a button and what exactly does that script do?

[thebrianexp]

here is my file. im not too good at explaining myself...

the record is an example when i click todo today what happens...

thebrianexp.zip

[mr_vodka]

First, you need to sepcify the field that you are setting...

SetField [ToDo::Date; Get ( CurrentDate ) - 7 & ".." & Get ( CurrentDate ) ]

Second, your layout 'Info Todo' should be based off the 'toDo' table occurence not Employee.