Mikhail

I've always checked the month field only; is there any circumstance is which this is not adequate?

cheers

Tom


On 4 Feb 2011, at 19:09, Mikhail Edoshin wrote:

> 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
>