Path: csiph.com!aioe.org!.POSTED!not-for-mail From: Helpful Harry Newsgroups: comp.databases.filemaker Subject: Re: Finding in a Script Using Dates with Wildcards Date: Wed, 05 Apr 2017 18:51:49 +1200 Organization: Aioe.org NNTP Server Lines: 20 Message-ID: <050420171851499161%HelpfulHarry@BusyWorking.com> References: <1n3z5a7.12we6wpxhv9ghN%csampson@inetworld.net> NNTP-Posting-Host: Pzl171PSpYGm1czmN9V2+w.user.gioia.aioe.org Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: abuse@aioe.org User-Agent: Thoth/1.8.4 (Carbon/OS X) X-Notice: Filtered by postfilter v. 0.8.2 X-Face: vIZzK[X\z-._]-_:U?l@cBtwg<{a>ggn\mH}Vs>38E,#R%7h%U0'=4;1Q=erO %[T#a{YJfGvAbWmE@f_h], Martin ‘§rautmann wrote: > On Tue, 4 Apr 2017 20:51:03 -0700, Charles H. Sampson wrote: > > > > How do you execute a find in a script using a date such as 3/*/2017? > > Whenever I try it, I get a message that "3/*/2017" is not a date. > > > > As usual, I'm still using FileMaker Pro 8.0v3 on a G5 running 10.5.8. > > Try 3/1/2017..3/31/2017 > Martin That would be the best way (although I thought it was three dots between the two dates). The Find Mode wildcards aren't really designed for anything except text. You could try using the function GetAsDate("3/*/2017"), but I doubt that will work either. Helpful Harry :o)