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!