AnsweredAssumed Answered

Date Format Calculation problem

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

Title

Date Format Calculation problem

Post

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.  

Thanks.

Outcomes