I think setting the field with Get(Current Date)+1
would also work, and avoids the month end problem? Regards Peter -----Original Message----- From: FileMaker Pro Discussions [mailto:[email protected]] On Behalf Of Will Cooksey Jr. Sent: 10 February 2010 15:16 To: [email protected] Subject: Re: how to write a script that searches for "tomorrow" in a date field Set Field [Search_Field; Month ( Today ) & "/" & Day ( Today ) + 1 & "/" & Year ( Today )] You could of course add in some if statement checks to make sure the +1 isn't going over 29, 30 or 31 on those months that apply. Will Cooksey Computer Support Specialist University of Arkansas University Information Technology Services [email protected] 479-575-2905 -----Original Message----- From: FileMaker Pro Discussions [mailto:[email protected]] On Behalf Of Stefan Garr Sent: Wednesday, February 10, 2010 7:03 AM To: [email protected] Subject: how to write a script that searches for "tomorrow" in a date field Hi I have a solution that has a date field. I'd like to write a script that always searches for tomorrow's date. I know that I can search for "today" using the // shortcut, but couldn't find a way to incorporate that knowledge into a solution. Thanks Stefan Garr No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.435 / Virus Database: 271.1.1/2666 - Release Date: 02/03/10 19:35:00
