didn't come from me... :)
> Bob -
>
> Don't you mean "11 ; 1 ; 2009" and "11 + 1 ; 0 ; 2009"?
>
> Bart
>
> Bart Bartholomay
> HAB Marketing
> 3725 8th Lane
> Vero Beach, FL 32960
> 772.299.6352
> Filemaker Business Alliance
>
http://HABMarketing.com>
>
>
>
> On Nov 7, 2009, at 1:50 PM, Bob Patin wrote:
>
>> Here's what I do:
>>
>> If I'm writing a script to allow clients to find invoices, for
>> example, I take them to a custom FIND layout (I use John Mark
>> Osborne's Ultimate Find script, which is very cool--worth looking
>> into);
>>
>> In the case of an invoice FIND, I have a pair of global date fields
>> that are set up with the calendar widget; on the layout I also put
>> a button that says "Current Month," as well as another that says
>> "Year to date," and usually another that says "Today". By clicking
>> on the "Current Month" button, for example, the little script puts
>> the first day of this month in the first field, and the last day of
>> this month into the other (here's where that calculation comes in
>> handy); the next step in this little script also puts the 2 dates
>> into the actual invoice DATE field like this:
>> "11/1/2009..."11/30/2009" (this field isn't displayed on the layout).
>>
>> So this way, a user can either put in starting & ending dates, or
>> click one of the 3 buttons to instantly populate the date fields
>> with one of the 3 choices.
>>
>> Best,
>>
>> Bob Patin
>>
>> Longterm Solutions
>>
[hidden email]
>> 615-333-6858
>>
http://www.longtermsolutions.com>> iChat: bobpatin
>> FileMaker 10 Certified Developer
>> FileMaker 9 Certified Developer
>> Member of FileMaker Business Alliance and FileMaker TechNet
>> --------------------------
>> FileMaker hosting and consulting for all versions of FileMaker
>> PHP • Full email services • Free DNS hosting • Colocation •
>> Consulting
>>
>> On Nov 7, 2009, at 12:01 PM, Seth Pomeroy wrote:
>>
>>> well this sounds brillant - a bit over my head but i like it -
>>> would the button populate those 2 fields or does the user enter a
>>> beginning date and an ending date?
>>>
>>> Bob Patin wrote:
>>>> Well, a great use is when you need to know the last day of the
>>>> previous month... for example, let's say you wanted to populate 2
>>>> fields with the 1st of the month and the last of the month; using
>>>> that trick you could put "11/1/2009" and "11/30/2009".
>>>> I do this often when I write universal FINDs, where I want to put
>>>> a button for the client that will FIND all the records for the
>>>> current month; when they click the button, it puts the starting &
>>>> ending dates in for them.
>>>> Another good use is to find the last day in February, since the
>>>> last day changes on leap years.
>>>> BP
>>>> Bob Patin
>>>> Longterm Solutions
>>>>
[hidden email]
>>>> 615-333-6858
>>>>
http://www.longtermsolutions.com>>>> iChat: bobpatin
>>>> FileMaker 10 Certified Developer
>>>> FileMaker 9 Certified Developer
>>>> Member of FileMaker Business Alliance and FileMaker TechNet
>>>> --------------------------
>>>> FileMaker hosting and consulting for all versions of FileMaker
>>>> PHP • Full email services • Free DNS hosting • Colocation •
>>>> Consulting
>>>> On Nov 7, 2009, at 11:47 AM, Seth Pomeroy wrote:
>>>>> thnks bob, this helps, makes sense now and it's cool but when
>>>>> would you ever need to use it? is it used in case of human error
>>>>> or something ethereal that's above my head?
>>>>> -seth
>>>> _______________________________________________
>>>> FMPexperts mailing list
>>>>
[hidden email]
>>>>
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-
>>>> ironclad.net.au
>>> _______________________________________________
>>> FMPexperts mailing list
>>>
[hidden email]
>>>
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au>>
>> _______________________________________________
>> FMPexperts mailing list
>>
[hidden email]
>>
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au>
> _______________________________________________
> FMPexperts mailing list
>
[hidden email]
>
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
