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
