Re: How do I validate these fields


"Jens Teich" <spamtrap@xxxxxxxxxxxx> schreef in bericht
news:m24oqgr1dm.fsf@xxxxxxxxxxxxxxx
davepres <davidpreswick@xxxxxxxxx> writes:

1) This is a text field and we input numbers but they must be 4 digits
eg 0412 or 1014. I want a message or warning if anything other than 4
digits is entered

Validate by calculation: length( text ) = 4

and make it numbers only


2) I have a date field and in the validate section I can only find
"validate for 4 digit year". I just want to make sure there is a valid
date eg 12/11/2009 or 05/10/14. (Australia uses dd/mm/yy or dd/mm/
yyyy)

FileMaker does this for you and will not accept other than valid date
data.

Jens

--
FileMaker Konferenz in Zürich Mai 2010
http://filemaker-konferenz.com (german)



--
Keep well / Hou je goed

Ursus


.

Relevant Pages

  • Re: How do I validate these fields
    ... digits is entered ... Validate by calculation: length= 4 ... "validate for 4 digit year". ... FileMaker Konferenz in Zürich Mai 2010 ...
    (comp.databases.filemaker)
  • Re: Need help validating a phone number
    ... What would the number of digits in a phone number have to do with its ... Only way to validate a phone number is to dial it. ... required to fill in a survey form on some computers over in the corner. ... there were hundreds of Australians skiing at their resort. ...
    (comp.lang.php)
  • Re: Need help validating a phone number
    ... Only way to validate a phone number is to dial it. ... The author of the survey form made the mission critical error of deciding that the "zip code" needed to be valid to make sure their demographics were not "tainted with invalid data". ... Well over here in .au we don't have zip codes, we have postcodes, four digits long. ... It was when I met the president of what was then the second largest ISP in the United states, who said 'Do you realise the market in Europe is worth nearly as much as the entire united states AND canada' that my jaw dropped, and I realised what a total utter parochial prick I had to deal with. ...
    (comp.lang.php)
  • Re: trouble with replace
    ... What I want to do is remove all Currency ... >symbols so that I can validate the number. ... I am in South Africa and so ... followed by exactly two digits it is most unwise just to remove the ...
    (microsoft.public.scripting.jscript)
  • help with cobol date
    ... I am trying to accept a date and validate it against today's date. ... I am getting the user to enter a date - 8 digits ddmmyyyy. ... date is comming out as YYMMDD, ... Is there a simplier way to check that the users date is less than ...
    (comp.lang.cobol)