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 >