Bill

Set Variable [ $CheckDate; Value:Library::CheckoutDate ] 
Set Variable [ $Now; Value:Get ( CurrentDate ) ] 
Set Variable [ $LoopDate; Value:$CheckDate ] 
Loop
	If [ DayOfWeek ( $LoopDate ) = 1 or DayOfWeek ( $LoopDate ) = 7 ] #Saturday or Sunday do do nothing
Else
	Set Variable [ $Days; Value:$Days + 1 ] End If
	Set Variable [ $LoopDate; Value:$LoopDate + 1 ]
	Exit Loop If [ $LoopDate > $Now ] 
End Loop
Show Custom Dialog [ Message: "Checked out for " & $Days & " Days"; Buttons: “OK” ]

Stephen

----------

"The nice thing about standards is that you have so many to choose from." -Andrew S. Tanenbaum, Computer Networks, 2nd ed, p.254





On Sep 16, 2010, at 10:36 AM, Stephen Wonfor wrote:

> Bill
> 
> A calculation with Get(CurrentDate) - CheckoutDate would work.
> 
> Stephen
> 
> -----
> 
> "Rivers know this: there is no hurry.  We shall get there someday." --- A.A. Milne
> 
> On Sep 16, 2010, at 10:15 AM, Bill Wallace wrote:
> 
>> I have been going through the filemaker knowledge base but cannot seem to find a solution to counting days. I would like to be able to count the days in a script so that when a student has a book out for 21 days or more from the checkout date. Then I would be able to red flag the student, until the book is returned.
>> 
>> Thanks,
>> Bill Wallace
>> Manzano Day School
>> Albuquerque  NM
>> [log in to unmask]