Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.filemaker > #2148

Re: Validating an Input Date

Path csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!aioe.org!.POSTED!not-for-mail
From Helpful Harry <HelpfulHarry@BusyWorking.com>
Newsgroups comp.databases.filemaker
Subject Re: Validating an Input Date
Date Sun, 12 Apr 2015 13:41:52 +1200
Organization Aioe.org NNTP Server
Lines 30
Message-ID <120420151341522081%HelpfulHarry@BusyWorking.com> (permalink)
References <1m2p1sc.onwnbc6d6k1iN%csampson@inetworld.net> <1m2pvlz.h1mf01dmsnwqN%clkaufmann@gmx.ch> <1m2q6cg.m2h1xwolhk40N%csampson@inetworld.net>
NNTP-Posting-Host mOqy4cP0XXECXLaJAGPqUg.user.speranza.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]<rQ30+q;vqA^FUVx%\9{@r{gt${p^.L~bemFF@WY$r9fhuA F"1)$0+MgN+j8OO<SAec%$P;!M4Aj/kVitK5\xKmed-/3$2LiT1nI!-lKjt0B!qP_E{V ja+\#+[_uq8",IkoIF3M0}}qCD(&
Xref csiph.com comp.databases.filemaker:2148

Show key headers only | View raw


In article <1m2q6cg.m2h1xwolhk40N%csampson@inetworld.net>, Charles H.
Sampson <csampson@inetworld.net> wrote:
> Christoph Kaufmann <clkaufmann@gmx.ch> wrote:
> > Charles H. Sampson <csampson@inetworld.net> wrote:
> > 
> > [FMP 8]
> > > Is there any way in FMP (not advanced) to validate that a text string
> > > contains a correct date? Such things as only digits and slashes and
> > > values that are correct for month, day, and year?
> > 
> > Use a date field to begin with?
> 
> My experiments show that you can input anything into a date field.
> Things blow up downstream when you try to use the bad "date".
> 
> At present, the only user-friendly processing I'm doing is using TrimAll
> with the last argument being 3, which squeezes out all blanks.
> 
> > If it's just a string outside a date field, you might start with the
> > filter function:
> > 
> > input =? filter ( input ; "1234567890/." )
> 
> Thats a new one to me. What does the "=?" operator do?

"=?" doesn't do anything - it's not a real operator. It's possibly a
typo or a bad conversion of a non-standard ASCII character by a
newsreader / newsserver.

Helpful Harry   :o)

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Validating an Input Date csampson@inetworld.net (Charles H. Sampson) - 2015-04-11 03:12 -0700
  Re: Validating an Input Date clkaufmann@gmx.ch (Christoph Kaufmann) - 2015-04-11 13:51 +0200
    Re: Validating an Input Date csampson@inetworld.net (Charles H. Sampson) - 2015-04-11 17:43 -0700
      Re: Validating an Input Date Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-04-12 13:41 +1200
      Re: Validating an Input Date clkaufmann@gmx.ch (Christoph Kaufmann) - 2015-04-12 07:24 +0200
  Re: Validating an Input Date Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2015-04-11 12:12 -0700
    Re: Validating an Input Date csampson@inetworld.net (Charles H. Sampson) - 2015-04-11 17:43 -0700
      Re: Validating an Input Date Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-04-12 13:54 +1200

csiph-web