AnsweredAssumed Answered

Build a unique ID using now()?

Question asked by ejapal on May 10, 2018
Latest reply on May 11, 2018 by ejapal


I would like to build an ID number based on the date and time as shown below:


Y=Year, M=Month, D=Day, Hr=Hour, Mn=Min

I am trying the now() function in the calculation column where I get a number reported as a value (see image) which .  Does anyone know how to interpret this value so I can convert it to my format?

Or does anyone know another way to create such an ID in the xls form?

Thanks for any help and or ideas!