Subject: | |
From: | |
Reply To: | |
Date: | Thu, 16 Sep 2010 10:46:28 -0600 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
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]
|
|
|