AnsweredAssumed Answered

Build a unique ID using now()?

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

Hi,

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

YYYYMMDDHrHrMnMn

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!

Ed

Attachments

Outcomes