marcm

Need help with add preceeding numbers to field

Discussion created by marcm on Mar 7, 2017
Latest reply on Mar 8, 2017 by Johan Hedman

Hi,

 

I have a calc field that gives the last 2 digits of the year and a reference number. i.e.  17-1, 17-15, 17-100

I need to make the reference number part always be 3 digits. 17-001, 17-015, 17-100

 

this is my current calc

 

Case(Right( Year(Get(CurrentDate));2) = Left(IncidNFD;2); Right( Year(Get(CurrentDate));2)  &  "-"  & ( Middle(IncidNFD;4;12)+1); Right( Year(Get(CurrentDate));2)  &  "-"  & "1")

 

How can I do this? Can't seem to figure this out.

 

thanks in advance

 

marc

Outcomes