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 [email protected] 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
