4 Replies Latest reply on May 9, 2011 8:48 AM by jamroman

    Date Format Calculation problem



      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.