Search results

I have 3 number fields [Month], [Day], [Year]. I would like to combine these 3 fields into 1 date field with the following format M/DD/YYYY. I tried DateSerial([Month], [Day], [Year]) without success. For example: When Month is 11, Day is 9, and Year is 1998 the DateSerial answer is...