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