I have the following formula in a calculation field:
Left ( Master::A1_Name_LastName; 3 ) &
Left (Master::A1_NameFirstName ; 2 ) &
Month (Master::A1_BirthDate ) &
Day ( Master::A1_BirthDate)
The A1_BirthDate field has both day and month Leading character set to zero in case the intake specialist forgets
to enter a zero.
Last Name: Golucky
Birth date: 06/01/2001
The result is: golha61
I need it to be golha0601
any thoughts on how I can get the leading zeros to show.