Date Format Calculation problem
As part of a calculation, I am using the field Date_of_birth as part of the formula. The outcome is affected depending of the date format. If the user says their date of birth is 6/15/2006, a particular result is given. If the same user enters the date as 06/15/2006, then the calculated outcome is different.
Is there a way to standardize the format regardless of the way the user enters the date? I have tried adjusting the date format within the Inspector tab, but this does not seem to make a difference.