2 Replies Latest reply on Mar 8, 2017 12:28 AM by Johan Hedman

    Need help with add preceeding numbers to field

    marcm

      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