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

Making 3 digits is something like

Let ( y = Right ( Year ( Get ( CurrentDate ) ) ; 2 ) ;

SerialIncrement ( y & "-001" ;

Case ( y = Left ( IncidNFD ; 2 ) ; Right ( IncidNFD ; 3 ) )

) //SerialIncrement

) //Let

But, isn't this field itself IncidNFD?? I guess you need to refer "last value in the same year".