AnsweredAssumed Answered

Generate ID starting with "1" every new year

Question asked by mai-kel on Jul 18, 2017
Latest reply on Jul 19, 2017 by mai-kel

Hi all,

 

I need to generate an ID following this structure "yyyy-xxx" whereas "yyyy" is the current year and "xxx" is an increasing number. This would be easily done with 

fn-FormatDate({Common:CurrentDate},yyyy)-{ItemProperty:ID}

BUT customer wants to start with "1" every new year... has someone already done this?

 

Cheers

mai-kel

 

increment id

Outcomes