FMPRO-L Archives

February 2011, Week 1

FMPRO-L@LISTSERV.DARTMOUTH.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Glitch in date calculation
From:
John Raid <[log in to unmask]>
Reply To:
FileMaker Pro Discussions <[log in to unmask]>
Date:
Fri, 4 Feb 2011 13:05:21 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (25 lines) 
Hi all,

in an application the user has to fill in the date in 3 separated number fields.

Day, month, year.

A calculation field:

Date(monthField ; dayField ; yearField)

will return the correct date, but 'not always'...

Suppose the user gives in 31, 02, 1964. (Feb 2, 1964)

FileMaker will return March 2, 1964, a clever deduction.

But the initial 'date' is wrong.

Is there an easy way to check if the combination of the 3 number fields is
an acceptable date?

Open for ideas.

TIA

ATOM RSS1 RSS2