1 of 1 people found this helpful
you could convert 09272015 (set to a variable like $enteredvalue first) with something like:
Left ( $enteredvalue ; 2 ) ;
Middle ( $enteredvalue ; 3 ; 2 ) ;
Right ( $enteredvalue ; 4 )
... but the above would only work with a consistent number of digits (8) in the entered value.
if the only variation included whether or not a leading "0" was included for months before October, then the following could work...
If ( Length ( $enteredvalue) = 7 ; "0" & $enteredvalue ; $enteredvalue ) ;
Left ( $convertvalue ; 2 ) ;
Middle ( $convertvalue ; 3 ; 2 ) ;
Right ( $convertvalue ; 4 )
so you will need to consider all the variations in the format of the data entered before you can come up with a suitable calculation... probably best to restrict the data type entered in the first place (e.g. if possible with your circumstance, just ensure that the field type is 'date'), or include 'script triggers' for OnObjectExit if the user has not used a certain format or a certain number of characters etc.
...sorry, I missed a closing bracket at the bottom of the Let calc above
Thank you stephensexton...I played around with the calculation and finally the one that worked for me is this:
DOB = Date of Birth
DOB = Filter ( DOB ; 1234567890 ) ;
Left ( DOB ; 2 ) & "/" & Middle ( DOB ; 3 ; 2 ) & "/" & Right ( DOB ; 4 )
I borrowed your formula as well as the "Help" in the program.
I am grateful.