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

Groups > comp.databases.filemaker > #2148

Re: Validating an Input Date

Show all headers | 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