"...As part of a calculation, I am using the field Date_of_birth as part of the formula"
Write here your actual calculaton.
MRNCALC = Last_name & First_name & MI & Date_of_birth
The value from this calculation is affected by whether the visitor enters their date_of_birth as 6/15/2006 or 06/15/2006. Depending on that extra "0," the correlated relationship is affected.
This value then populates a field of which a unique visitor ID number relationship is correlated. New visitors get a new ID number and follow up visits produce the visitor number from the prior visit.
I need to "foolproof" the Date_of_birth entry to a standard format the generates the same Date_of_Birth regardless if a single or double digit numeric birth month or day is entered. I have tried the inspector date format field and this did not help.
Thanks a lot.
Change the calculation ( result text ) to:
Last_name & First_name & MI & GetAsDate ( Date_of_birth )