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.

Outcomes