AnsweredAssumed Answered

Leading zero dropping in a formula

Question asked by wcallman on Sep 28, 2018
Latest reply on Oct 3, 2018 by beverly

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

First: Happy

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.