AnsweredAssumed Answered

Date Format Calculation problem

Question asked by jamroman on May 8, 2011
Latest reply on May 9, 2011 by jamroman


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.