Hi John,

Try to read back month, day, and year of the calculated date and see if they match the input:

Let( d =
  Date( monthField, dayField, yearField );

  /* The input is valid if the following holds */

  Month( d ) = monthField and Day( d ) = dayField and Year( d ) = yearField )

Kind regards,
--
Mikhail Edoshin
[log in to unmask]



On Feb 4, 2011, at 9:05 PM, John Raid wrote:

> 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