Here is what I've used as a calculated value concat(YEAR(Entry Date)-2000,round(datediff(Entry Date,$$TODAYby))-1,right(Reference Number,3)) This is an 8 digit number that is the two digit year, 3 digit julian day (i.e. day of the year) and the last 3 numbers of the WF generated Reference Number. Th...